Skip to main content
derrickr8850025
derrickr8850025
Level 2
February 6, 2019
Solved

Advanced Expression

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Jonathon_wodnicki
    Jonathon_wodnickiAccepted solution
    Community Advisor
    February 8, 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

    View in thread

    3 replies

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity Advisor
    Community Advisor
    February 6, 2019

    Hi,

    Charindex('ë', Trim(@bothFromTableA)) > 0

    Thanks,

    -Jon

    Translate
      derrickr8850025
      derrickr8850025Author
      Level 2
      February 8, 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?
      Translate
      Jonathon_wodnicki
      Community Advisor
      Jonathon_wodnickiCommunity AdvisorAccepted solution
      Community Advisor
      February 8, 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

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...