Join Failure

Question

I have two inputs to my join. Some months both inputs have data, some months only 1 has data. On the months only 1 has data my join outputs no data unless I delete the empty input. How do I fix my workflow so the join will output data every month, even if only 1 input has numbers?

apathetichell · Answer

I use text input/dynamic rename/union - but sounds like you solved your issue.

NBPSE · Answer

Thank you for the suggestion. I used a Data Cleansing tool to replace Null values with zero (Numeric Fields). This allowed the columns to carry forward and the join to work whether one or both inputs have data.

NBPSE · Answer

What would you do to create a dummy datastream? What tools would you use to architect this successfully?