Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
iahmadmca1
Contributor III
Contributor III

Compare two table field with flag.

Team,

I am using the below code logic to compare the two fields.It is working with small data but whenever using the huge value of data it is getting stuck.could you please suggest me an alternate solution for this.

Tab1:

LOAD * INLINE [

    A, Key

    1000, 1

    1001, 2

    1002, 3

    1003, 4

    1004, 5

    1005, 6

];

join

LOAD * INLINE [

    B, Key

    1000, 1

    1010, 2

    1020, 3

    1003, 4

    1040, 5

    1005, 6

   ];

FinTable:

LOAD *,

          if(A=B, 'Yes', 'No') as OWM_Flag

                      

Resident Tab1;

DROP Table Tab1;

Thanks,

Irshad Ahmad

22 Replies
iahmadmca1
Contributor III
Contributor III
Author

Sunny, I have made the above answer as helpful.

sunny_talwar

Thank you, I would have liked if would have marked correct response also, but may be you are not seeing an option to mark it, else you would have done it (I think).

Best,

Sunny

sunny_talwar

Thank you iahmadmca1