topic Comparing two data tables from excel in QlikView

Comparing two data tables from excel

Woojtek_96 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'm new in qlickview, and want to make some comparsion. So I have two tables with the same columns names with different values and I want to compare those values (probably i have to do this by if statement) and if values do not match i want to show something like error message and then count those error to show (for example on a chart )the differences between values in columns.

Best regards

Wojtek

Re: Comparing two data tables from excel

mrtinsjoao — Thu, 23 May 2019 13:42:53 GMT

Great Day.
I think the most easy way to compare dates are, Join this Two tables. after join, compares with if loading again the table with resident command.
Follow de example:
Table A, Table B;
left join(A)
LOAD * Resident B;
drop table B;

noconcatenate
TempA:
LOAD *,if(DateA>DateB,'UHUL','NO') as Comparison
RESIDENT A;
drop table A;
Rename Table TempA to A;