Need urgent help: split data by columns

[user1850275]

Hi all - 

I need help with splitting my data file into different tables split by column. I need all columns with one data source together and the others together, but right now they are in the same file. 

Apples	Apples	Banana	Banana
data	data	data	data

Make it to:

Apples	Apples
data	data

and 

Banana	banana
data	data

I dont want to merge the data -> just seperate it out into different tables

[griffinwelsh]

Are there more than 2 groups in your actual data set and are you wanting the tables output as separate files or just separate anchors in your workflow? One issue that you will run into is that Alteryx does not allow duplicate column header names like you show in your data structure. You can still run the transformation but you will get field numbers appended to your column headers unless you are exporting a file that supports this format.

[user1850275]

seperate anchors in my workflow

that's fine; field numbers can get appended its okay with me I do need seperate workflows for each of the groups of tables

[Qiu]

@user1850275 
We can not have the same field names but if we output to Excel, we can play some tricks.

We still use the appended field names but blend the original header into data field and Choose "Skip Field Names" when outputting to Excel.
End up a Batch Macro. 😁

[user1850275]

Hi, 

I want to be able to do this without a batch macro: I have some similiar columns and I want to split by the type of column it is and split into different tables; I undestand I can do this with the select tool but is there a more efficient way for alteryx to seperate out the columns and create new tables: the rows are not changing; each table is only changing by the columns we are selecting.

Revenue2021

Revenue2022

Revenue2023

Sales2021

Sales2022

Sales2023

Cancellations2021

Cancellations2022

Cancellations2023

I want to seperate it out so that it looks like: 

Revenue2021

Revenue2022

Revenue2023

is one table; and the rest are created as similiar tables