community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More

Split table using values of two fields

I have the table below, and I want to split it to sub tables according to all possible combinations of Region AND Org. I know there is an option in output to filter according to field name but in my case I am using two fields, and I want to export each table into a separate file/

 

Thanks

 

Facility NameEquip SerialRegionOrg
GG43444.648419213Region#1Org#1
HH43444.648419213Region#2Org#2
II43444.648419213Region#3Org#3
JJ43444.648419213Region#4Org#4
KK43444.648419213Region#5Org#1
LL43444.648419213Region#6Org#2
MM43444.648419213Region#1Org#3
NN43444.648419213Region#2Org#4
OO43444.648419213Region#3Org#1
PP43444.648419213Region#4Org#2
QQ43444.648419213Region#5Org#3
RR43444.648419213Region#6Org#4
SS43444.648419213Region#1Org#1
TT43444.648419213Region#2Org#2
UU43444.648419213Region#3Org#3
VV43444.648419213Region#4Org#4
WW43444.648419213Region#5Org#1
XX43444.648419213Region#6Org#2

 

Quasar

@atheeralattar

 

A lot depends on what you want to do with the tables after 'splitting' them.

 

You can use custom filters in the Filter tool using expressions like

 

[Region]="Region#1" AND [Org]="Org#1"

 

Alternatively, if it's just to output based on these combinations, then what about just adding a new column using a formula that concatenates Region and Org and use that to set table or sheet names?

 

If you can share a little more information about the overall flow, we'll be able to help more

Thanks for your reply, I want to export each table into a separate file (I have updated my question). So basically I have (Master File) and I want to split it to these small combination each to standalone Excel file. I hope that clears out my task.

Quasar

I had just updated my original comment. How about just adding a new column using a formula that concatenates Region and Org and use that new column to set table or sheet names?

That was exactly what just came to my mind and wanted to share it :D I am trying that now. Thank you so much

 

It worked well, except now I want to generate separate files not sheets?

Labels