Discussion board where members can get started with QlikView.
I have this data:
Notice that [Assoc Ids] has a delimiter. Based on this delimiter, I need to split the values into individual rows and copy the data for the other fields onto each of those rows.
Resulting table would be like this:
Go to Solution.
Where Len(Trim([Assoc Ids])) > 0;
SubField([Assoc Ids], '-') as [Assoc Ids];
LOAD * INLINE [
Key, Type, Assoc Ids
1, AAA, 123
2, BBB, 555-234-123
3, CCC, -123-999
View solution in original post
You could just use: subfield([Assoc Ids], '-') within the load of the table to create these records. Subfield without a third parameter worked like a loop.
Attached you will find a solution that is working.
I guess we have similar approaches, but I suggest using Preceding load based on some testing done by Rob