Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Headers are removed after unique tool

8 - Asteroid

Hi all,

 

I am very new to Alteryx and have searched my question but cannot seem to find the answer.

I apologize if this has been asked and answered elsewhere.

 

I am basically trying to perform a few things then remove duplicate fields grouping by the ID.

However, I see that the first row/headers get removed after that and I;m not sure what I have done wrong?

 

Below is the image before the headers are removed (select)

 

hal_dal_0-1579907018029.png

 

then below, you'll see the headers are gone after it runs with unique tool

hal_dal_1-1579907164010.png

Highlighted
7 - Meteor

@hal_dal 

 

I am not sure why you are losing that first row of data - it might be automatically sorting the data and putting the row down further in the dataset.  In that case, prior to the unique tool, add a Dynamic Rename tool to take headers from the first row of data.

 

This should solve your issue.

Highlighted
Alteryx Certified Partner

That is unusual @hal_dal, however you could use the dynamic rename tool before your unique tool to convert the first row of data to headers using a rename mode of "take field names from first row of data"?

 

If this solves your issue please mark the answer as correct, if not let me know!

 

Regards,

Jonathan

Highlighted
8 - Asteroid

Thanks to both!

I was able to figure out that it got sorted all the way to the bottom so what you both have told me seemed to fix it!

Labels