commands

[austin1111]

how to do comands

[binuacs]

@austin1111 One way of doing this

[austin1111]

Hi that works, thanks! but the formula does not capture all the unique names. I have already sorted the numbers as ID (1) and the names as ID (0). is there a way to find the unique values of each name, as the current unique function in alteryx sorts it by numbers, thus jumbling up the data.

[binuacs]

@austin1111 @Can you upload a sample input file and expected output result for better understanding?

[austin1111]

@binuacs i need to do the input in the sample to the 2 outputs, using alteryx

[binuacs · Accepted solution]

@austin1111 Can you try now?

[austin1111]

thank you it works now!