Discussion Board for collaboration related to QlikView App Development.
I have 3 tables (A,B,C) and i want to compare text field from a table to text field from C table.
LOAD * INLINE [
I tried to use this function if(TEXT1=TEXT2,null(),'Different') as expression in my Straight table and it works perfectly with the example tables.
But when I tried to put in in my real tables (every table has 2,000,000 records) it stuck.
Instead of using this in straight table, do the same in script, so that the performance would be better.
LEFT JOIN (A)
if(TEXT1=TEXT2,null(),'Different') AS Status
DROP TABLE A;
Hope this helps you.
View solution in original post