Do Data Shuttle Input Expressions work to build a key column?

lschek1 · 05/16/24

I have this sample dataset, I want to test Input Expressions to upload data and have it mapped to the Unique Identifier Column, which is Column7. When I run this workflow, there are no changes done nor added rows.

This is the formula I used in Input Expressions (I named it Column0): ="ID: " + [Column1]@row + " ; Name: " + [Column4]@row

I can use in this example Column1 to map values, but the reason I'm asking is because I have a more complex dataset that I need to concatenate to create a key column to compare against the grid, and that workflow does not work either.

Tim C · 05/16/24

You can't have an expression make a key ID and map it in a sheet from what I know. Could you make it in your source file?

Tim C · 05/16/24

You can't have an expression make a key ID and map it in a sheet from what I know. Could you make it in your source file?

lschek1 · 05/16/24

Thanks for the confirmation, that's what I did after. Just wanted to know if that was possible without creating the column in the source file.

Do Data Shuttle Input Expressions work to build a key column?

Best Answer

Answers

Categories