Multiple tabs in Alteryx

[Economicus3]

Hi! I would like to ask whether it is possible to create multiple tabs in Alteryx and if not is there any alternative?

[kumaranvr1984]

Hi,

Do u mean can the alteryx produce multiple tab output? or single workbook should split and create in multiple tabs?

Can you please elaborate your question?

Regards,

Kumaran 

[echuong1 · Accepted solution]

Yes, it is possible. You would need a separate output data tool for each tab to be created. Configure them all to write to the same file/file path. The sheet name will be the tab name. 

Hope this helps!

[Economicus3]

I mean the second one. So, if Alteryx can produce multiple tab output.

Regards,

Ajda

[kumaranvr1984]

Hi,

To create multiple tab output you can use block until done tool then use a separate output data tool for each tab to be created. 

If you are using table / Pivot then use separate formula tool to create sheet name after each table  then combine then use layout to align then render tool to output. 

Regards,

Kumaran

[Economicus3]

Not sure if we understand each other. So, is it possible that yxdb file consists of multiple tabs just like excel file?

Regards

[kumaranvr1984]

Hi,

I do not think that we have such option in alteryx for yxdb, but you can use workflow groups yxwg to group the workflows

Regards,

Kumaran.

[joshbennett]

Hi @Economicus3,

If you are asking whether you can have multiple "tabs" (i.e., partitions of the data) within Alteryx's native file type (.yxdb), the answer is no. If you are wanting to reflect multiple data sources within a single file, you can (obviously) use different sheets in an Excel file or you can use a SQLite database file (.sqlite), which permits multiple independent tables / views to exist within the file.

Hope that helps, 

Josh