Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Duplicates after Transpose tool

skumari
6 - Meteoroid

Hello Team,

 

I have a dataset where I have few columns with yes or no values, I need to convert them into categories and take count of all 'Yes'. so the category that has tow yes should take 2 as a count I can achieve that using transpose but I am not able to remove duplicates. Please suggest.

 

Attached is the sample workflow.

4 REPLIES 4
CharlieS
17 - Castor
17 - Castor

If you're just interested in the sum of each category, then the "Group By" of the Customer ID, Area, and Country fields should be removed.

 

In the attached example solution, I added a different Summarize tool that produces these counts, and appended the other fields as a concatenated string of values. I also included a different method for the data preparation using the Multi-Field Formula tool.

 

Let me know if this is what you're looking for.

skumari
6 - Meteoroid

Thanks, Charlie for your reply, actually that's the challenge here, I need category and count on the same line as other fields. I have tried setting record Id and later taking unique but then it gives me only partial data.

CharlieS
17 - Castor
17 - Castor

Happy to help! When you say "same line", do you mean you want the same Category value to be used for all lines, or something else? A manually-entered Excel example output would be a great way to share your ideal output.

 

 

skumari
6 - Meteoroid

Thanks Charlie, I have realized that if we take out other fields as you said would give us desired result because i have got a pivot from my customer and they only take two feilds category and the count so it is easy, I have to check with them again., but your input on making output on excel clarified my doubts too. Thanks you so much.

Labels