Fields are missing from join.

[markp201]

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?

[pcatterson]

Check your left and right flows with some browses.  There is probably some null values in both places which are matching.

[markp201 · Accepted solution]

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.

[RodL]

FYI...When joining on Key Field, Alteryx sorts the records behind the scenes in order to make the join more efficient.

[sujithgk]

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 .