Data Shuttle Expression Not Working

Hello,

I'm trying to create a Unique ID using an expression in Data Shuttle that looks at three columns. First, if there is a value in column A, then use that, if not use column B to create the first value (Value 1). Then I'm checking in column C to see this there's a value (Value 2). Then, I create the Unique ID, by looking for Value 2, if that's blank I use Value 1, if there is something in Value 2, I use that + Value 1.

Problem is, nothing happens when I run the data shuttle.

Any ideas on why this isn't working?

Thanks!

Find more posts tagged with

Data Shuttle

Accepted answers

All comments

Neil Watson

Can you share a screenshot of the expression?

Tim Dollmeyer

Here's the expression:

=IF(ISBLANK(IF(ISBLANK([Current Requisition]@row), [Filled Requisition]@row, [Current Requisition]@row)), [Position ID]@row, [Position ID]@row + "-" + (IF(ISBLANK([Current Requisition]@row), [Filled Requisition]@row, [Current Requisition]@row)))

It works in the sheet, just not in the Data Shuttle expression.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.