update column value based another column value in tmap (pivoting)

[sakura99]

Hi all, so I have columns that should be updated from the other columns on tmap.

The picture looks like this:

Desc : Every level pivoting into VA, VB, VC, VD,& VE

How to do this properly? Thank you for your time

[Anonymous]

Hi

You can try tDenormalize+tExtractDelimitedFields components, let me know if you have any questions.

Regards

Shong