Here is my flow - very simple summarize and a join
Left and right join are empty yet some fields are null for the inner join.
How is this possible?
Thanks for the pointer but found the issue. I don't why but join sorted the rows which had the ill effect of putting the nulls at the top.
Check your left and right flows with some browses. There is probably some null values in both places which are matching.
yes even i got the same issue, but my workflow works with realtime data , so sometimes the data will be NULL, and it has to perform a join operation. But in this case how to handle the issue when my data is NULL .
