Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Edith1
Creator
Creator

How to parse comma delimited file with json array columns

I have a comma delimited file (.CSV) and there's a few columns that have json array data. I need those columns to be split into 1 column but its splitting into several columns. How can I do that?

Here's an example of 1 data row: 

mhsge@xx.com,John,Doe,"[{""FieldName"": ""Upload"", ""FileName"": ""CSWE2023_Ps.pdf"", ""FileName"": ""851171f2-9821c3.pdf""}]"

Here's the setting for the input: 

  • 1st column does result in the email 
  • 2nd column does result in first name
  • 3rd column does result in last name
  • ISSUE: 4th column splits into several columns and I want the entire string data for the json array
    • splits into 3 columns: 
      • "[{""FieldName"": ""Upload""
      • ""FileName"": ""CSWE2023_Ps.pdf""
      • ""FileName"": ""851171f2-9821c3.pdf""}]"

Edith1_0-1730310790981.png

Thank you in advance!

 

Labels (2)
0 Replies