Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER 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...
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

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...
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
sureshbaabu
Creator III
Creator III
Author

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