Not able to append and join data from Union tool

[SubbuSharma]

Hi All, 

I am trying to join the files which has updates in HoC Update/Comments (column I) however, in column A  one of the records (# 8) are appearing twice and throwing off my calculations. Could you please help me a dynamic solution.

[SubbuSharma]

Correct, the workflow is reading all the records but not sure why it's not picking the result (2nd one after ABCD) in the column "HoC Update/Comments

HoC Update/Comments

ABCD

*

IJKLM

NOPQ

RSTU

VWXYZ

[Luke_C]

Hi @SubbuSharma 

I think this is more of an issue in how you're using the unique tools rather than an issue with the inputs. Using a unique tool keeps the first instance, instead you might want to filter out the asterisk records to get what I think you're looking for.

If this is not what you're looking for can you please be crystal clear on what your requirement is? 

[SubbuSharma]

Hi @Luke_C 

This is awesome, it works for me. Thank you again for your patience :)

[Luke_C · Accepted solution]

Great! Be sure to mark the solution if you're all set