Multiple Field values in Single filter- How can we make it associative

[new_user30]

Hi,

I have 3 columns Column A, Column B, Column C residing in same table. I need to create a filter with the distinct values of this 3 columns, and when I apply filter or select any particular value which belongs to Column A, the data should get filtered based on only Column A. Is this can be achieved?

  Source Table

A	B	C	D	E	F	G
aa1	bb1	cc1	de	er	we	ok
aa2	bb1	cc2	de	ert	df	jk
aa2	bb1	cc2	ds	yt	vb	hjg
aa3	bb2	cc3	dg	fd	kjl	ww

Filter Needed in below format:

aa1

aa2

aa3

bb1

bb2

cc1

cc2

cc3

Output :

In the filter if I select value aa1, only the first row should get displayed.

[Digvijay_Singh]

See if this can help -

[new_user30]

Thanks for the reply Digvijay.

But if I use the above query, only Column A will get affected. Actually I need the filter to have functionality over all the 3 columns.

Sorry that I have mentioned a particular column name in the question, I was trying to give an example.

What I meant was, the filter should posses distinct of all 3 columns and if I select a particular value, the respective Field should get filter out.

So

Output : In the filter if I select value aa1, only the first row should get displayed.

If I select value cc2, then second and third should be displayed.

[Digvijay_Singh · Accepted solution]

In attached one I get what you mentioned when I select cc2.

Can you elaborate the actual business need, may be we can meet requirement by some other means.

[new_user30]

Thank you Digvijay, this is what exactly I want.

[eknezo24]

Hi Digvijay,

Is there a way to open your .qvf file without the Sense Desktop application? I think this is exactly what I need to solve a problem I'm having but I can't open the file. Do you happen to have the script in a text document?

THANK YOU!

Best,

Elise

[SateeshGuntupally]

Hi ,

I want to combine multiple field values in single field/filter in filter pane not using data load editor.

Eg: field1 field2 field3

       aa1     bb1     cc1

filter

aa1

bb1

cc1

if we add this code in data load editor getting performance issue.

Can you please help me out how can we make it associative in filter pane itself instead of data load editor.

Thanks,

Sateesh

[SateeshGuntupally]

Hi Digvijay,

Could you please help me out.

Best,

Sateesh

[jjustingkm]

Hi Digvijay ,

Could you please provide this in a word document or text file , had some difficulty opening this in my work laptop due to security constraints.

Thanks,

[manoranjan_d]

Hi ,

I tried with cross table

below is the script and o/p screen shot let me know your o/p meet

T1:
LOAD
D,
E,
F,
G,
A,
B,
C
FROM
[C:\Users\NM\Desktop\Scenarios\17 feb21\New Microsoft Excel Worksheet.xlsx]
(ooxml, embedded labels, table is Sheet1);

T2:
CrossTable(Filter, Data_of_3feilds,4)
LOAD *
Resident T1;