Need your help to solve this problem
I have If condition in my expression I am trying to convert into Set Analysis but its not working
see my attached file.
Please post expression?
I think that won't work as you tried it because you have to compare it row by row...
btw. there are null() values within your comparision, I'm not sure, if you thought about it...
With the help of an outer join + flag, it is possible:
(ooxml, embedded labels, table is Sheet1);
month(Unlink_Date) as Month_Temp,
Year(Unlink_Date) as Year_Temp,
Date(Date#(Unlink_Month_End,'MM/DD/YYYY'),'DD-MM-YYYY') as Unlink_Month_End
(ooxml, embedded labels, table is Sheet2);
if (Date>=Unlink_Month_End,1) as FLAG
DROP Table TEMP;
Excuse me, but I can not understand what information your table contains with condition IF? This table is a union of many-to-many two unrelated source tables, and plus with the condition IF. What kind of task is solved in general?
hm, he builds a carthesian product due to no matching fields.
So when he calculates
he does an indirect outer join
I'm also not sure, if that is desired at all.
But there is one problem with this code when I apply above code with large amount of data it take lots of memory and processing