Data Shuttle Workflow Error

annie.wong107591
annie.wong107591 ✭✭✭
edited 06/14/22 in Add Ons and Integrations

Im not quite sure what does this error mean? Ive created workflow on Data Shuttle.

Smartsheet_DataShuttle_NameWorkflow_SEM.JPG
Smartsheet_DataShuttle_Expression_SEM.JPG
Smartsheet_DataShuttle_Run_SEM.JPG
Smartsheet_DataShuttle_Mapping_SEM.JPG
Smartsheet_DataShuttle_Filter_SEM.JPG
Smartsheet_DataShuttle_Target_SEM.JPG
Smartsheet_DataShuttle_Source_SEM.JPG
Smartsheet_DataShuttle_WorkflowError.JPG


Smartsheet_DataShuttle_WorkflowError.JPG
SEM and Display Master Strategy Doc_05.21.22 (1).xlsx


· Share on FacebookShare on Twitter

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭

    @annie.wong107591

    On the Mapping setup, the column you've identified as the unique identifier column needs to actually be unique. I believe what the error is telling you is that that column has the same exact value over 300 times in both the source file and destination sheet.

    The way Data Shuttle works it needs a column with a value that is truly unique and doesn't repeat over and over in either the source or target sheets.

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video