Group by and bring all the rest columns based on the group by value

[Mhnd]

Hi 

I have data in three columns:

• [FileName] contains 14 unique name.
• [name]
• [value]

I want separate the dataset based on the unique [filename] and bring all values of [name] and [value] which belongs to that [filename], I could do filter tool and repeat it 14 times but i want something smarter than this.

Thanks

[binu_acs]

@Mhnd Do you want the output in separate tabs in an excel file, like unique1, unique2, and unique2 or three different excel file?

[binu_acs]

@Mhnd The attached workflow will create 3 separate tabs in the same excel

[Mhnd]

Thanks, but I do not extract them to output file, I have to complete the workflow after the separation

[binu_acs]

@Mhnd How you want the output then?

[Mhnd]

I could do like this but i think there is a smarter way than filter tool.

Then I have to complete the workflow. 

[binu_acs]

@Mhnd Dynamic filter is possible in Alteryx, but what would be your next step after filtering the data? If you provide that part also I can create a batch macro based on your requirement, which will be dynamic