Remove Duplicate and assign data into single row

Rahul6777

Hi Team,

Please see the below mention scenario, I have provided the dummy data as well for reference.

In my scenario, there is flat associated with each ID based on the category (Flag it true or False). We have a category in row that is why flag is giving true or false value.

Eg. If contain (category, Active) then flag 1 and Flag2 is true elsif contain (category, Miscellaneous)

Then flag 3 and flag 4 is true so on.

 Now I want a single row for each ID and their respective flag data into a single row to remove the company and ID duplicity.

INPUT DATA
ID	Company	Category	Flag1	Flag2	Flag3	Flag4	Flag5	Flag 6	Flag7
KJFDBC1234	ABC1	ACTIVE	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE
KJFDBC1234	ABC1	miscellaneous	FALSE	FALSE	TRUE	TRUE	FALSE	FALSE	FALSE
KJFDBC1234	ABC1	directory	TRUE	TRUE	FALSE	FALSE	TRUE	FALSE	FALSE
GHJHD5679	Company2	Hyper	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE
GHJHD5679	Company2	Active	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
Output Data
ID	Company	Category	Flag1	Flag2	Flag3	Flag4	Flag5	Flag 6	Flag7
KJFDBC1234	ABC1	ACTIVE, miscellaneous, directory	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	FALSE
GHJHD5679	Company2	Hyper, Active	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	TRUE

Yoshiro_Fujimori

Hi @Rahul6777 ,

If you want to set True for a company for a flag with at least one "True", you can simply use "Max" in Summarize tool.

I hope it helps.

Workflow

Summarize tool configuration

Output

SummarizeBoolean.yxmd