XML Column parsing

[gaurav_sandil]

Hi,

I have a table which contains the following columns:
ActionID, DataTypeCD, Data, ActionDataID

These columns have below values in it:

1. ActionID = 123

2. DataTypeCD = DDV2

3. Data =
   
   LETR
   CROM
   MOBL
   IOSS
   SNTS
   DQLF
   

4. ActionDataID = 456

Now I want to have the 9 columns with their respective values as:

1. ActionID = 123
2. DataTypeCD = DDV2
3. Channel = LETR
4. Browser = CROM
5. Device = MOBL
6. OpertaingSystem = IOSS
7. WordExport = SNTS
8. SurveyAction = DQLF
9. ActionDataID = 456

I tried using XML Snaps but couldn’t achieve the desired result.
Please help me in solving this problem statement.

Thanks,
Gaurav Sandil

[SandeepVemula]

Use Join SNAP

[gaurav_sandil]

Thanks. I tried using the Document to Binary snap and it worked for me.