Data Shuttle: No Unique Identifier Column

Paul H

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?

Genevieve P.

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