Getting matching values for the two different values!

Q&A
, ,
1

select
distinct

table.a,
table.b,
table.c,
table.d,

table.a as a1,
table.b as b1,
table.c as c1,
table.d as d1

from table

This is my script so i have taken the same column from same table but with different alias name.

now in the analysis page i will create two tables,

first table will include a, b, c, d and same i will create the filters also but this filter will not applied to second table
second table will include a1, b1, c1,d1 and same i will create the filters also but this filter will not applied to first table

now i will select few values from the first tables filter and few values from the second table filter but filter values will diffrent from both the filters.

after applying the filter i want to see only the matching values in both the tables i dont want to see the unmatched one.

for example whatever a and a1, b and b1 value should be same accross both the tables.

so basicall requirement is the client want to with the diffrent filter value what all are matching values are there.

please help me with this one to achieve thank you in advance.

2

Hi,

You can create a view based on two table and create the matching.

where b.id = a.id and other condition you want to show as matching.

Regards,
Naveed Ali

3

Hello @Naveed,

Thank you for your response!

I am not using two tables i am using single to pull the columns it just i am using different alias name to pull the columns two times.

So that i can apply diffreny values and see related to these two diffrent what are the same values.

Please let me know if you need more clarification thank you.

4

Hi @Deepak1,

The use case is not clear, however I understand you want to compare a with a1 and b with b1.
You can create a calculated field to check a=a1 and return TRUE or 1. Based on your requirement use OR/AND clause to check b=b1 and likewise. Use this calculated field as common filter to both visuals to be able to show only matching rows.

This solution may not be the optimum one. Please add more details of the use case if possible or a snip of expected output in an excel.

Thanks,
Prantika

5

Hello @prantika_sinha,

Thank you for the response !!

Below are my requirements hope this is helpful,
Note:- This data is coming from the same dataset

image
image1319×449 14.9 KB

6

Hi @Deepak1 ,

Here (Sample solution 28May) is a sample arena dashboard created basis the data you shared. Have tweaked the data a bit to check use cases.

Please check if this is what you were looking for.

Thanks.

7

Hi @Deepak1,
It’s been awhile since we last heard from you. Checking in to see if Prantika’s solution helped with what you were looking for or if you have any remaining questions?

If we do not hear back within the next 3 business days, I’ll go ahead and mark as the solution.

Thank you!

8

Hi @Deepak1,
Since we haven’t heard back, I’ll go ahead and mark the solution. However, if you have any further questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!