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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

track changes

I have developed a job thats supposed to track changes by comparing two sources and create an output insert. My tMap has a variable expression defined as below. My records are in millions of rows and performance it not very good. Any ideas please. - thank you in advance.

 

source1.customerid.equals(source2.customerid) && source1.hashing.equals(source2.hashing)? "no change":"changed"

 

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

It seems you don't have a join between input rows (not sure because you have reduce everything). You should (must) have a left outer join then, depending on result you'll decide which output flow to address.

View solution in original post

5 Replies
TRF
Champion II
Champion II

Can you share the tMap?

What kind of join do you have between the main and the lookup row?

Anonymous
Not applicable
Author

Here is my tMap


mgs.png
Anonymous
Not applicable
Author

0683p000009M7pB.png

Anonymous
Not applicable
Author

I have posted it below.
TRF
Champion II
Champion II

It seems you don't have a join between input rows (not sure because you have reduce everything). You should (must) have a left outer join then, depending on result you'll decide which output flow to address.