Blank rows in middle of output

[jboschee]

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!

[MarqueeCrew]

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

[jboschee · Accepted solution]

@MarqueeCrew

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. 

[MarqueeCrew · Accepted solution]

@jboschee,

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