This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm very new to Alteryx.
I grouped my data by name.
After I selected Group By from the Table tool and I used the Render tool to export it to Excel file, each group of data was split in separate tabs.
Is there anyway to make them appear in one tab?
Example: these 2 tables appear in the same tab in Excel sheet with headers for each group and some space between each table.
This is likely to be happening because of the configuration in your output tool and how you are outputting this. If the data is coming in as one table, the default settings for an export should be for it to all appear on one tab. See this article on the output tool which should help - https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Output-Data/ta-p/30023 or in the help documentation https://help.alteryx.com/2018.2/DbFileOutput.htm
Let me know if this helps
Thank you so much.
I really appreciate it.
I will read the document and see if I can work around with that.
Thank you again,
A workaround of sorts that will still require a bit of cleanup in Excel.
You can insert one or more extra columns (I called mine "Hold" in the attached example) into the original data.
Then, after the table tool creates records per your grouping, use the Layout tool to combine them horizontally together.
After you render to an Excel table, open the file and remove all of the extra columns to hold the space.
Please let me know if that works for you.
Thank you so much!
I'm going to try it.