YAML data Cleaning

[lalitkgehlot89]

Hi,

I have YAML data in a table column.

Please help me to clean that data in qlik. Sample data file attached for reference.

Thanks

LK 

[Qrishna]

the strings are too lengthy.

This resemble a complex nested json structure, not json though.

by the way whats the expected column list? i mean the table and its fields?

[Kushal_Chawda]

@lalitkgehlot89  There is no direct function or method load YAML data into qlik sense. Probably you need to convert it to other format which is readable in qlik sense like JSON or CSV.