Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

How to split into two tabs multiple columns in excel file in Alteryx?

Aziz_Bebitov
5 - Atom

Hi,


Can someone help me on how to split into two tabs that I have in a single excel file in Alteryx. I have 12 columns in the file and 6 columns have to go the first tab and the other 6 columns have to go to the second tab of the same file. I have to do it in output. 

Thanks!

 

2 REPLIES 2
DQAUDIT
9 - Comet

@Aziz_Bebitov 

 

My suggestion would be to follow your input tool with a Block Until Done Tool.  On the first output anchor use a select tool for the necessary columns and write to one Excel Tab, on the second output anchor add another Select Tool to mark columns needed for the second output and then write that to the other Excel Tab.

 

Good luck.

Aziz_Bebitov
5 - Atom

Hi there, it worked perfectly, thanks very much!!!

Labels