Data Shuttle Expression Not Working
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?
Help Article Resources
Check out the Formula Handbook template!