Union

[aparna0208]

Need some help. Please see attached workflow for reference. I have 2 outputs that I'm trying to write to an excel file. When I union both outputs along with date, there are nulls. But I need an output like below. I tried data cleansing and couple other tools but not able to get rid of empty fields and get the desired output with just one row.

Fail	Inspection	DateTimeNow
10,000	87,000	11/12/2020

[christine_assaad · Accepted solution]

Hi @aparna0208 

Please check this out. Cheers!

[aparna0208]

It worked:) Thanks a lot @christine_assaad