Do Data Shuttle Input Expressions work to build a key column?
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.
Best Answer
-
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?
Answers
-
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?
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- I've set up a archiving workflow using an archive checkbox column in our intake sheet through our blueprint. When this criteria is met, the project is supposed to be moved into an archive workspace, t…
Anyone has a problem Datamesh error code 1302;You cannot edit cells with Column Formula for column(0
Dear Support, I created a Datamesh with lookup value from a Formula column (source column), once run the config, then show error "code: 1302; message: You cannot edit cells with Column Formula for col…- Hi all, I was just informed by our I.T. Dept that Microsoft is killing the Outlook Add-in. We use this add-in quite extensively. Is anyone out there aware of a quick and easy way to attach emails to s…
