In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Removing Duplicates but merging the rows with missing information

wingtc99
6 - Meteoroid

Hi, I have merged two sets of lists together, now I am trying to get a unique list. The problem is that list 1 is does not contain the middle 3 columns, which results in a null.

 

wingtc99_1-1633351903378.png

 

I have used the unique tool, however it removes rows with full sets of data and leaves the rows with nulls as a unique row, is there a way to merge and auto fill this so that I could get a row such as:

 

Armada Boat Hire, XYZ, 123, XYZ, XYZ. 

 

Thanks

1 REPLY 1
Christina_H
14 - Magnetar

The unique tool will always take the first row for each item, so just sort it to make sure the populated rows come first.

Labels
Top Solution Authors