Complex CSV + XML combined loading

Follow

Anson Chan

• May 05, 2021 15:24

Hello Team,

I have a use case whereby the source is a CSV file - tabular format (in rows) with entries of XML elements within. A sample structure as below:

The target orientation of the data I'd like to get to is to be able to extract those XML values, those fields becoming a column so a row of data describes all the attributes of that action logged at that time.

There are also entries where the XML structure is "nested".

Under this circumstance, Do you have tips and tricks to share with us so we can realize the data set that is cleaned and ready for analysis?

Thanks,

Anson

0

• 

  Konsta Danyliuk

  • May 05, 2021 15:29

  Hello Anson.
  
  I guess it would be more convenient to handle this request via a support ticket. May I ask you to create a support ticket and share the source file or at least its sample, so we could review the structure.

  Thank you in advance.

  0

  Comment actions Permalink
• 

  Anson Chan

  • May 05, 2021 15:30

  Thank you Konsta, I shall do so rightaway. Please bear with me as I'd need to mask and change the data set for support raising. I will retain the structure as is, just changing the fields.

  0

  Comment actions Permalink
• 

  Konsta Danyliuk

  • May 05, 2021 15:32

  Sure, feel free to obfuscate real data or replace it with some random values, we just need to understand the structure. 

  0

  Comment actions Permalink

Please sign in to leave a comment.