community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Cross Tab with identical strings

Atom

Hi,

 

I am using Cross Tab on the data set below where I group Column Type by Reference so for reference 29115742 the Output will be 2A2B because reference 29115742 has 2 rows. Reference 29120410 has 4 rows therefore the Output will be 2A2A2B2B. Can you please tell me whether is there a way to change the output for 29120410 to 2A2B so that it will only take the first identical value?

Thanks!

N

 

Current output:

 

ReferenceTypeOutput
291157422A2A2B
291157422B2A2B
291204051A1A1B
291204051B1A1B
291204102A2A2A2B2B
291204102A2A2A2B2B
291204102B2A2A2B2B
291204102B2A2A2B2B

 

Desired output:

 

ReferenceTypeOutput
291157422A2A2B
291157422B2A2B
291204051A1A1B
291204051B1A1B
291204102A2A2B
291204102A2A2B
291204102B2A2B
291204102B2A2B

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Norbi 

 

Just to be clear, what is your input before using Cross-Tab tool?


Cheers,

Atom

Hi Thableaus

 

I have attached the relevant part of the workflow.

Basically uses Reference and Type.

Many thanks!

 

Aurora

Hi @Norbi 

 

If your data is identical and you don't want to see it duplicated after the cross tab, use a Unique tool to remove the actual duplicates.  In your case, select Reference and Type as the fields to check for unique values.  

 

Dan

Atom

Many thanks to you both!

It works for me.

N

Labels