08-22-2018 11:03 PM
Hi,
I have a table which contains the following columns:
ActionID, DataTypeCD, Data, ActionDataID
These columns have below values in it:
ActionID = 123
DataTypeCD = DDV2
Data =
LETR
CROM
MOBL
IOSS
SNTS
DQLF
ActionDataID = 456
Now I want to have the 9 columns with their respective values as:
I tried using XML Snaps but couldn’t achieve the desired result.
Please help me in solving this problem statement.
Thanks,
Gaurav Sandil
08-26-2018 10:36 PM
Use Join SNAP
08-27-2018 09:37 PM
Thanks. I tried using the Document to Binary snap and it worked for me.