Advanced Expression

derrickr8850025

06-02-2019

Hey guys

I am trying to convert some Teradata code into an advanced expressions in Adobe. Would any know how to do the following in Adobe?

POSITION('C0'XC IN TRIM(BOTH FROM TABLEA) > 0

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

wodnicki

MVP

08-02-2019

Hi,

Bad info I got from this page: ASCII Table. If you have access to shell it's `echo -e '\xc0'` which will show something else.

Either way, you're probably better off using the sql functions directly, which you can expose by following this guide:

Note this will only work in limited scenarios with FDA, where the query is executing on the Teradata side (targeting dimension is a td schema). To verify sql is as expected, use preview in the query dialog or turn sql tracing on for the workflow.

Thanks,

-Jon

Answers (2)

Answers (2)

derrickr8850025

08-02-2019

Ok a few questions:

1: How did you do the e? What keyboard commands that?

2: And the query will eventually look like this?

(Position('C0'XC IN Trim (Both From cc.household_demographics_key)) > 0 
OR Position('C1'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR Position('C2'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR Position('C3'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR
Position('C4'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR Position('C5'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR
Position('C6'XC IN Trim (Both From cc.household_demographics_key)) > 0
OR Position('C7'XC IN Trim (Both From cc.household_demographics_key)) > 0.....

How would you do that?