Data Shuttle Expression Not Working

Tim Dollmeyer

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!

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.