Hi everyone, I need a away to transform this input: AmountDateCode123.98|113.132023-01-11|2023-01-17TB|TB10000.00|19606.00|10000.002023-05-30|2023-06-30|2023-04-24TB|TB|TB To this output:AmountDateCode123.982023-01-11TB113.132023-01-17TB10000.002023-05-30TB19606.002023-06-30TB10000.002023-04-24TB The thing is: - The values will always be different;- Sometimes I may have to separate in two rows but other times can be less or more, according how many "|" I have.You can check the example attached. I hope you can clarify me.Thank you,Beatriz Help Example.yxmd

Parse more than 1 column at the same time

Hi everyone,

I need a away to transform this input:

To this output:

The thing is:

- The values will always be different;

- Sometimes I may have to separate in two rows but other times can be less or more, according how many "|" I have.

You can check the example attached. I hope you can clarify me.

Thank you,

Beatriz

In Database

In-Database

@beacc One way of doing this

@beacc One way of doing this

Thank you so much 😀