topic Re: Compare two non linked feilds in QlikView

Compare two non linked feilds

sujit_nath — Sat, 16 Nov 2024 00:20:16 GMT

I have 2 different tables that have no relation between them. I just want to compare 2 column from each of those and tell if the values in one column are there in the other (basically compare the values in both)

Is there a way this can be achieved? NB - There is no relation between these two tables.

Re: Compare two non linked feilds

tresB — Mon, 13 Jul 2020 05:44:28 GMT

There probably is a way. Even if the tables are not associated the fields values would be associated (as if) as in cross-join case. You could get the values something like:

=Concat(Distinct if(Field1<>Field2,F1), ',') // to get the comma separated values in a textbox

Re: Compare two non linked feilds

sujit_nath — Mon, 13 Jul 2020 10:22:11 GMT

Actually, this halts my qvw, maybe this is too ram intensive. As a workaround, I've tried left join. Let's see, I'll post here if I get an other alternative.