topic Extracting Data from Filed Value in QlikView

Extracting Data from Filed Value

sureshbaabu — Sat, 16 Nov 2024 03:38:51 GMT

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

Re: Extracting Data from Filed Value

Vegar — Tue, 07 May 2019 18:31:33 GMT

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/ScriptRegularStatements/Load.htm

Re: Extracting Data from Filed Value

sureshbaabu — Mon, 13 May 2019 10:56:08 GMT

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