Data Shuttle Filter and Mapping

Options
May Deng
May Deng
edited 11/21/22 in Add Ons and Integrations

Hi Dear guys,I am a newbie of Datashuttle. I have read the article in Learning center but still could not know how the upload function work.

For example, when I creat a new workflow to upload the content from google sheet "Smartsheet attach - Data shuttle test" to target smartsheet "H&H PSC Integrated Master Plan - 总表demo", when I run, it didn't work. Any setting didn't correct?

Below is the setting for Filters. "开始年份(means start year)“ equal to 2020

and for Mapping setting, set "Start Year" as Unique Identifier Column and make Source field "开始年份(means start year)" matched the "开始年份(means start year)"

But when I insert rows in source google sheet, and run the Data Shuttle workflow,the new row didn't appear in the target Smartsheet. Below is the information. It seems that it didn't work, right?

Is any issue in my fiters or mapping? What is the right way to do it? Waiting for your helps. Thanks.


Tags:

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 11/11/22
    Options

    Hi @May Deng

    Based on your screen captures it looks like you should be selecting column B as your "unique identifier column" in your second image (Project Number? or Business Name?)

    Currently you have the Start Year selected as the "unique" value, but this data is not unique: your second and third rows also have 2020 in their Start cells, so the new row with 2020 will be seen as a duplicate. Does that make sense?

    Cheers!

    Genevieve