I need to make a field transformation such that if the field value starts with “DOK”, then I want to replace the value with “1001”. I tried to set up this custom field transformation using something along the lines of CASE WHEN …, but didn’t manage to get this to work. How would I write this code in TX?
Solved
Custom SQL Query using LIKE
Best answer by rory.smith
Hi
the best way to implement IF-THEN-ELSE constructions is by using Fixed transformations and conditions:
In this example TimeXtender will load the Description from the ODX and only replace with 1001 if the Descriptions starts with DOK . The basic approach is to have Data Movement or Fixed Transformation as the default (the ELSE) and then add transformations with conditions (IF THEN) for all the cases you want to support. There is no break statement, so all transformations fall through. This means your conditions should lead to disjunct cases, or you need to depend on the ordering of the transformations (most specific case last).
+7Hi
the best way to implement IF-THEN-ELSE constructions is by using Fixed transformations and conditions:
In this example TimeXtender will load the Description from the ODX and only replace with 1001 if the Descriptions starts with DOK . The basic approach is to have Data Movement or Fixed Transformation as the default (the ELSE) and then add transformations with conditions (IF THEN) for all the cases you want to support. There is no break statement, so all transformations fall through. This means your conditions should lead to disjunct cases, or you need to depend on the ordering of the transformations (most specific case last).
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
