Need urgent help: split data by columns

Question

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.

ApplesApplesBananaBananadatadatadatadata

Make it to:

ApplesApplesdatadata

and

Bananabananadatadata

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

AncientPandaman · Answer

you may use dynamic select tool.

it can used like filter to filter the column. it just need build once.

user1850275 · Answer

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.

Revenue2021Revenue2022Revenue2023Sales2021Sales2022Sales2023Cancellations2021Cancellations2022Cancellations2023

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

Revenue2021Revenue2022Revenue2023

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

Qiu · Answer

@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. 😁

0711-user1850275.yxzp