I carried out a left outer join using the Joiner node. I would like to retain the row order even if no join is made. Currently all the rows that have no join are pushed to the bottom of the table. Is there anyway around this? Thanks.
Hi Macca,
This is not done automatically by the Joiner, but it is fairly easy to add a rowindex colum usign the Math Formula node and then following that up with a post join sort.
Hope this helps,
Regards,
Aaron