topic Re: Different columns comparision in QlikView

Different columns comparision

priyarane — Fri, 06 Oct 2017 09:50:23 GMT

hi Community,

Can you please share any thought you have for the below requirement.

I have 2 tables,

Table1:

Dim1,Dimx,Dixy,Join_key;

Dim2,Column1,Colmn2,if(Dim1=Dim2,1,0) as Complex_Key,Join_key;

in the 2nd tab I have two create Complex_Key based on table1,

can you please share your thoughts.

it is not possible to have Exist function.

-Priya

Re: Different columns comparision

tresB — Fri, 06 Oct 2017 10:08:56 GMT

You can use exist function too I guess. However, to create Complex_Key, you have to load the table for one extra time and that too after the join has already happened. In other words, first join the tables, then create the new field in another load using resident load of the joined table.

Re: Different columns comparision

priyarane — Fri, 06 Oct 2017 10:16:14 GMT

exist will check all the values but here it is '=', so exist cannot be used

Re: Different columns comparision

tresB — Fri, 06 Oct 2017 10:26:00 GMT

If you want to just create a flag, then exist() won't help. Exist() could help you if you want to discard few values being loaded.

Re: Different columns comparision

antoniotiman — Fri, 06 Oct 2017 10:32:24 GMT

May be like this

LOAD * From Table1;

LOAD *,

If(LookUp('Dim1','Join_Key',Join_Key,'Table1')=Dim2,1,0) as Complex_key

From Table2;