create a list based on multiple column values

[#1]

Hi, I have a requirement to create a list based on multiple column values

Eg:

I have this data

Column1	Column2	Column3	RowNo
abc	ghi	def	1
jkl	abc	def	2
jkl	def	xyz	3
ghi	jkl	abc	4
mno	abc	jkl	5

Now, I need  a dropdown with values abc,def,ghi,jkl,mno,xyz.

If I select any value in the dropdown I  need to get all the rows that have the value in any of the columns-1,2,3

i.e, if I select abc in the dropdown, I need to get 1,2,4,5 rows.

if I select def, I need to get the rows 1,2,3

[sunny_talwar · Accepted solution]

Try this:

Table:

LOAD Column1,

    Column2,

    Column3,

    RowNo

FROM

[https://community.qlik.com/thread/213805]

(html, codepage is 1252, embedded labels, table is @1);

LinkTable:

LOAD Column1 as ColumnSelection,

  RowNo

Resident Table;

Concatenate (LinkTable)

LOAD Column2 as ColumnSelection,

  RowNo

Resident Table;

Concatenate (LinkTable)

LOAD Column3 as ColumnSelection,

  RowNo

Resident Table;

[#3]

Thanks