Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 listbox containing these values.
Listbox1 |
---|
NAME |
ADDRESS |
TELEPHONE |
Listbox2 |
---|
ALEX |
JOHN |
EMILY |
New York |
London |
Trenton |
8923492929 |
8234234334 |
3434392929 |
I need to form the table like this:
NAME | ADDRESS | TELEPHONE |
---|---|---|
ALEX | New York | 8923492929 |
JOHN | London | 8234234334 |
EMILY | Trenton | 3434392929 |
I could only separate the rows of listbox1 using
LOAD listbox as NAME FROM [./address] where listbox1 like 'NAME';
How can i separate rows of listbox2? Any ideas?
Thank you
What is the source of your data? This is something you would want to resolve in the script, right?
Hey.. Sorry I was not clear about my source of the data. My source was from an xml file which i then added into excel to look like this because it seem more better for me.
I think i found the answer from this post Converting rows into multiple columns | Qlik Community which worked for me.
Though I have a question. I am attaching my sample excel file which is similar to this one and I want to group the data in the format like this.
ID | NAME | GROUPS |
---|---|---|
123 | William | 1 |
123 | William | 23423 |
12314 | RAJ | 1 |
12314 | RAJ | 312 |
12314 | RAJ | 34 |
12314 | RAJ | 3242 |
23232 | John | 32 |
23232 | John | 43223 |
23232 | John | 122344 |
23232 | John | 1321 |
Load RowNo() as link, A as [ID]
FROM [SAMPLE>XLSX](ooxml, no labels, table is Sheet2)
where B = 'ID';
Left Join LOAD RowNo() as link, A as [NAME]
FROM [SAMPLE>XLSX](ooxml, no labels, table is Sheet2)
where B = 'NAME';
I was able to join the ids and names using above method but since there are multiple groups, this technique is not working for groups. Can you suggest something?