topic Re: How to form a table from 2 listboxes containing different attributes in QlikView

How to form a table from 2 listboxes containing different attributes

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to form a table from 2 listboxes containing different attributes

sunny_talwar — Wed, 28 Feb 2018 17:23:54 GMT

What is the source of your data? This is something you would want to resolve in the script, right?

Re: How to form a table from 2 listboxes containing different attributes

Anonymous — Thu, 01 Mar 2018 16:38:47 GMT

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?