Avatar

Michelle Lam

Sales engineer

  • Total activity 37
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 1
  • Subscriptions 19

Activity overview

Latest activity by Michelle Lam
  • Avatar

    Michelle Lam created an article,

    BrainScript Only: How to Exclude Columns in your Data

    There are various ways to exclude columns in your data in Dataverse. This article provides some examples. THIS ARTICLE IS ONLY RELEVANT IF YOU ARE USING BRAINSCRIPT.  In Dataverse we recommend usin...

  • Avatar

    Michelle Lam created an article,

    How to read multiple worksheets from Excel

    This article covers how to read data from Excel when you have data on multiple worksheets.    Scenario 1) I have data on multiple Excel worksheets that I want to use as a single data set Example: S...

  • Avatar

    Michelle Lam created an article,

    Can the Excel File node handle blank rows in the middle of the data?

    If your data is in Excel and has blank rows, Dataverse will still read these records but populate the values with NULL. For example, my data in Excel looks like the following - as you can see, rows...

  • Avatar

    Michelle Lam created an article,

    How to clean up leading or trailing white spaces

    It's often a good idea to clean up any potential leading and trailing white spaces in your data set early on in your process.  The Data Quality indicators in the Data Viewer provide you with inform...

  • Avatar

    Michelle Lam created an article,

    Frequently Used Nodes and Functions in Dataverse

    In Dataverse, the key buildings blocks for easily building your logic or your "data flow" are the nodes and functions that come pre-built into the product. A node is an individual piece ...

  • Avatar

    Michelle Lam created a post,

    Exclude specific rows from your data

    To exclude specific records from your data, some useful functions are the following: where - A keyword commonly used in conjunction with emit to control the output based on a condition. execCoun...

  • Avatar

    Michelle Lam created an article,

    How do I perform an Excel VLOOKUP in Dataverse?

    To perform a lookup similar to the VLOOKUP in Excel, you can use the Lookup node, which you will find in the Correlation category of the Nodes Panel in the Dataverse Designer User Interface. Note: ...

  • Avatar

    Michelle Lam created an article,

    BrainScript Only: How to change a date value to a formatted string

    This article provides an example of how you can format a field with date data type to a string field with a different format. THIS ARTICLE IS ONLY RELEVANT IF YOU ARE USING BRAINSCRIPT.  In Dataver...

  • Avatar

    Michelle Lam created an article,

    BrainScript Only: How can I correct or amend my data by replacing text?

    A common function to use in this case would be the replace function. The replace function allows you to perform a "find and replace" of text and doesn't require you to change your source ...

  • Avatar

    Michelle Lam created an article,

    Getting Started with Dataverse: Third Party Demographic data

    When working with data to produce reporting and analyses, it is often valuable to incorporate third party data to provide a view of your data that would otherwise be unavailable. For example, what ...