Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What I did:
DataTable:
Load
Name,
ID1 &
ID2 &
ID3 as ID
From DataSource
I have also tried inputting separator in-between (ID1&'|'&ID2)
IF ID1~3 are in format: 12-123456
then the first method gave me
Name | ID |
---|---|
John Doe | 12-12345612-12345612-123456 |
whereas the second method gave me
Name | ID |
---|---|
John Doe | 12-123456|12-123456|12-123456 |
However, I want the table to do this:
Name | ID |
---|---|
John Doe | 12-123456 |
John Doe | 12-123456 |
John Doe | 12-123456 |
Thanks
Try like this
DataTable:
LOAD Name,
SubField(ID, '|') as ID;
Load Name,
ID1 & '|' & ID2 & '|' & ID3 as ID
From DataSource
You can load this by
load
Name,
ID1 as ID
from YourSource;
load
Name,
ID2 as ID
from YourSource;
load
Name,
ID3 as ID
from YourSource;
In a table you will so only one line because Qlik shows distinct values in tables, but your data model contails 3 times lines of your source.
Regards
I wanted to avoid this route because I didn't want to load tables multiple times (especially if I have more ID#). Thanks for the suggestions.
Thank you. I did not think of using the subfield.
Maybe crosstable load is an Option.
Regards