Discussion board where members can get started with QlikView.
I have data like below in excel
I want to load above as below mentioned table structure in data model
May be as attached:
Load * Inline [
SubField(Items,',') as Items
Drop Table Source_Data;
View solution in original post
Table: LOAD Group_Id, SubField(Items,',') as Item FROM File (html, codepage is 1252, embedded labels, table is @1);
I have 60 fields in my application out of which 32 of them are comma separated and I want each of those comma separated fields to be split into different rows.
What is the best practice?
1. To use SubField(Field1,',') as Field1 for each of the 32 fields?
2. To have the Subfield for each of those feilds done in the application level or to be done while generating the QVD?
When I tried either of the option, I am getting error: Request ran out of memory
3. Does using the SubField() have any performance issue because of using it times in one application?
What is I have way more unique items and combinations in one cell? How can I copy and load inline all of it? ot there is other solution?
As of this example, Subfield is working for me. Like showing comma seperated values in different rows.
But, My Issue here is Iam getting duplicate values. each values twice.
I used Subfield(Item,',') in Expression sheet. I am getting values like bread
Please help me with this
Thanks in advance.