Extracting Data from Filed Value

[sureshbaabu]

Hello,

I have requirement to extract data using the column/ field Value in a table.

In the attached Data file - 

Column 1: ID 

Column 2: XML Data is stored as column value .

Requirement : I would like to retrieve data stored in column 2 on another table.

There are 3 columns (Product, LotNumber, ValueUSD ) within the XML data column (Column 2).  So, I need  retrieve 2 rows to get populated with data for 3 columns.

I believe this can done thro a loop by creating a row number and passing the same on the 'From' statement .

Could someone please share your thoughts on implementing this.

Thanks

[Vegar · Accepted solution]

I think you should look into the functionality
LOAD FROM_FIELD
Where you can treat already loaded fields as a LOAD source.

I would be something like my mockup code below.

ExcelData:
LOAD ID, XML_Data FROM EXCEL;

XmlResult:
LOAD [Product type], etc...
FROM_FIELD (ExcelData,XML_Data) (XmlSimple, Table is [RepeaterData/Item/etc/etc]);


https://help.qlik.com/sv-SE/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

[sureshbaabu]

Thanks for the suggestion. I have tried 'From_Field' and was able to import data using XML.