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.

Find more posts tagged with

Data Shuttle

Accepted answers

Tim C

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?

All comments

Tim C

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

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.