Duplicates after Transpose tool

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.

Sample_Trasnpose issue.yxmd

Transformation

Accepted answers

CharlieS

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.

20181019-Sample_Trasnpose issue.yxmd

All comments

CharlieS

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.

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

20181019-Sample_Trasnpose issue.yxmd

skumari

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703