Hi
I have data in three columns:
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
@Mhnd Do you want the output in separate tabs in an excel file, like unique1, unique2, and unique2 or three different excel file?
Thanks, but I do not extract them to output file, I have to complete the workflow after the separation
@Mhnd How you want the output then?
@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