Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Woojtek_96
Contributor III
Contributor III

Comparing two data tables from excel

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

1 Reply
mrtinsjoao
Contributor III
Contributor III

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;