Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sunny, I have made the above answer as helpful.
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
Thank you iahmadmca1