Hi everyone,
I'm getting blank rows in the middle of my output after a multi-join. I'm not seeing it before the join, only after. Same number of records before and after the join.
Any ideas?
Thanks!
Solved! Go to Solution.
I'm guessing that there is data off to the far right if you scroll across the browse. These are the unmatched left records.
Just a guess.
Cheers,
Mark
Hi Mark,
For some reason it looks like it's not taking input from source 1 of the multi join. My multi join I thought was pretty straight forward since all I'm doing is bring in Fx rates by currency code.
The join multiple was set to allow for unmatched records in output. The data from inputs 2 & 3 had additional rows that were being inserted into input 1 (based on sort key order).
Cheers,
Mark