Data Shuttle: No Unique Identifier Column

Paul H
Paul H ✭✭✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

The source data list items in multiple warehouses. To uniquely identify each row I would need refence both the item number + warehouse name. Is it possible with data shuttle?

Answers

  • Hi @Paul H

    You would need to already have the unique identifier column set up before building the Data Shuttle workflow.

    In Smartsheet, this can be created through a formula by adding together two cells in other columns, like so:

    =[Warehouse Name]@row + [Item Number]@row

    However your other data source will need to have a matching/corresponding column with the same data in it so that the Data Shuttle workflow can identify each row.

    If you have access to it, I would recommend reviewing the Data Shuttle eLearning training, here.

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now