Adding the data and split the data using common field

[munipavankumar]

Hi Team,

I've attached a sample dataset containing two fields: 'Market' and 'Type.' My Alteryx workflow needs to split the data into separate Excel files based on the 'Market' field, with each file further divided into sheets based on the 'Type' field.

While I've achieved this functionality using a macro, I'd like to incorporate some custom fields specific to each 'Type' across all markets before the data is split.

I've attached the workflow and sample data for your reference. Any assistance would be greatly appreciated.

Thanks,

[binuacs]

@munipavankumar how you want the additional fields to be displayed in your output file? Like below?

[munipavankumar]

Hi @binuacs @Thanks for your reply. It is almost correct. But, I don't want like this. You can observe that, in the Sheet 1 I have all the fields. But I want only. 1.1, 1.2, 1.3. Similarly for sheet 2 I want 2.1, 2.2 like that with customer fields.