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

[Raj]

Please find the sol attached 
Hope this help

[Yoshiro_Fujimori · Accepted solution]

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

[Rahul6777]

The True and False value in Boolean so not able to concat the field in summarized tool.

[Yoshiro_Fujimori · Accepted solution]

@Rahul6777 , 

You may want to use "Max" instead of "Concatenate".

From my observation, Alteryx regards True is "larger than" False.

So if you set "Max",

you will get True where the group contains at least one True,

and get False where the group contains only False.

[Rahul6777]

Thank You for the reply, I will implement the same and let you if any issue occur.

[Rahul6777]

Hi Raj, It can contain true or false both based on category value can you please help to send logic for true and false.

[Rahul6777]

Thank You @Yoshiro_Fujimori  and @Raj for the help.