Group By?

Dear All,

I'm pretty new in Alteryx and have some trouble.

I'm want to group the fields by a specific but I have no idea how. The images below are showing what I have (first image) and what I'm trying to reach.

Maybe it's in easy move I have no idea, but very thankful for every help or hint.

Best

Transformation

Accepted answers

grazitti_sapna

Hi @Uzi , try this if it helps.

If this is what you are looking for please give a like and mark this post as solution.

Thanks.

GroupBy-GS.yxmd

grazitti_sapna

Hi @Uzi , I have changed the default setting of the headers and turned it to yellow and red as required also I am getting the output as you desire the check and signature column remain in first and last place.

Please refer to the workflow. If it helps kindly mark this post as solution.

Thanks.

GroupBy-GS-updated (modified).yxmd

All comments

grazitti_sapna

Hi @Uzi , try this if it helps.

If this is what you are looking for please give a like and mark this post as solution.

Thanks.

GroupBy-GS.yxmd

Uzi

Thank you very much grazitti, the solution with my example worked perfectly.

What I didnt mentioned is, that my table has more fields and some fields are duplicated. so what I tried is to merge them together with the "Unique"-tool. But the outcome wasn't what I wanted 😕

Example given:

What happens is that the code number (which isn't 1,2,3, it is a kryptical number of like 10 digits). We have the Code number in File A, File, File B and so on. So Wanted to merge them together. Which worked but, also appears right in the table and I have no Idea how to deselect this fields (Select Tool is not working because it only shows me the "table" and not the single fields). What I want is just the Column "code and A, B, C).

Is there a way to "clean" the table?

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335