I have column X which having 3 values A;B;C. How can I load these values into 3 diff cols in the target. If tomorrow I will receive 100 values for same single column I will load into 100 target cols respectively (Same de-limiter) ?

Roopa

• Mar 2nd, 2018

Using Field function. Field(column,delimeter,1) and so on

ABACHREK

• Mar 3rd, 2017

Loop through the incoming field using looping functionality in transformer. Extract the individual values using field function and the iteration number. Output the individual values to the output link...

Answer Question  Select Best Answer