How to do Except in qliksense

[UpendraReddy]

Hi,

Any one can suggest me how to use except in qliksense.

I have following scenario attached.

Sheet1 having 11 records

sheet2 having 7 records which are available in sheet1.

My requirement is how to get the not matched columns from the both sheets(i.e.,4 records)

Thanks in advance.

BR,

UpendraReddy Mekala

[Dalton_Ruer]

I think what you need is a WHERE NOT EXISTS clause. You would load the table you want to ensure you keep values for first and then do a CONCATENATE LOAD for your second table using that clause.