Hi Experts,
I have tow tables with duplicated ids due to sub category and the other table due to key/value columns.
Sample tables:
Table A :
Rid diskid
1 d1
1 d2
2 d1
2 d5
Table 2 :
Rid key
1 k1
1 k2
2 k1
2 k5
I want to report on the counts of Rids and diskids.But when i join its going to cause duplicates and give me a incorrect count.
i can do a composite key and do distinct on it but is there a way i can associate two tables without being joined just like qliksense Association concept.