Multi output for file

[simonaubertbd]

Hello,

Many times, you have to "split" your output dataset in several parts, such as one sales excel file for each business unit. There is this nice feature on Alteryx that allows to do it and i would like the same : you can write like a file by value of a specified field :

There are several options, I especially like the one where you can specify the full path.

here this Output Data tool is configured to create a separate file for each value in the Region column and append that value to the end of the file name.

Four .YXDB files are generated:

1. "OutputToolExample_RegionGrouped_Midwest.yxdb"
2. "OutputToolExample_RegionGrouped_Northeast.yxdb"
3. "OutputToolExample_RegionGrouped_South.yxdb"
4. "OutputToolExample_RegionGrouped_West.yxdb"

On excel we can also imagine more solutions like "sheet" by value of this field or "file" by value of this field.

Please note the checkbox to include or not the field.

Best regards,

Simon

[tgourdel]

Thanks, I like this. Am I correct to assume that such feature would have its own "component" ?

[simonaubertbd]

Hello @tgourdel Well, I see that more as on option of the existing output tools.

Best regards,

Simon