Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sureshbaabu
Creator III
Creator III

Extracting Data from Filed Value

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

 

 

Labels (2)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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...

View solution in original post

2 Replies
Vegar
MVP
MVP

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
Creator III
Creator III
Author

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