XML Column parsing

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

Use Join SNAP

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

1 Like