Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the attached Document.
I have a field called IsItMissing which I was expecting a value of 1 for the IdNo 3?
Any ideas as to why?
Thanks
Yes.
You create a field IsItMissing while loading rows from the second table. All areas in that table are present. ONLY THEN are you performing a LEFT JOIN to a table where the new records may have NULL values in Area. That's too late for IsItMissing.
Solution: add an additional step to reload the JOINed table into a new one, and create IsItMissing in that LOAD statement.
The field value is only NULL in your resulting table after the JOIN, not when you are LOADing your second inline table.
You would need to do the check in a resident load of your resulting table to check for a NULL in the JOIN'ed tables.
Yes.
You create a field IsItMissing while loading rows from the second table. All areas in that table are present. ONLY THEN are you performing a LEFT JOIN to a table where the new records may have NULL values in Area. That's too late for IsItMissing.
Solution: add an additional step to reload the JOINed table into a new one, and create IsItMissing in that LOAD statement.
Hi,
How would I do the additional step? Would you be able to show as I do not understand?
Thanks
See the attachment to my previous post.
Best,
Peter
Hi,
You need to have a resident load after the left join and there we need to add the field. Please check the attached file.
Thanks, Jai