Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Separate Excel Columns into Tabs

Saravanakumar
7 - Meteor
ProgramLocationWeekdayStart TimeEnd TimeDurationFreqABC1ABC2ABC3ABC4ABC5ABC6ABC7ABC8ABC9ABC10ABC11ABC12ABC13ABC14ABC15ABC16ABC17ABC18ABC19
Program1Location1Mo18:00:0018:30:00308108.3084.6087.00129.6064.8096.5066.60122.0073.40112.6084.90109.40103.9083.50163.50151.20120.70164.2065.60
Program2Location2Tu18:00:0018:30:003017131.0087.6079.70105.9061.6073.1071.9094.5080.0088.7091.10108.6091.5085.30158.00133.7098.60146.4071.20
Program3Location3We02:00:0003:00:005813121.3066.9092.8064.1069.4068.40107.2062.9087.7068.0074.3095.0066.90103.60117.50103.0065.6076.3089.50
Program4Location4Mo25:24:0026:00:00361114.5086.7095.4075.7073.6071.50108.5075.5090.7079.7093.40101.5074.90108.20132.30114.6080.3084.60107.10
Program5Location5Fr20:00:0023:00:001802104.00144.90116.9079.40114.7087.40111.70114.10101.90122.20132.2094.00108.3098.20117.30129.0089.6091.70148.40

 

I have a table above in Excel. I would like split this table in a way that Columns from 'Program' to 'Freq' remains in all tabs but ABC1 Tab should have only ABC1 in addition

 

ProgramLocationWeekdayStart TimeEnd TimeDurationFreqABC1
Program1Location1Mo18:00:0018:30:00308108.30
Program2Location2Tu18:00:0018:30:003017131.00
Program3Location3We02:00:0003:00:005813121.30
Program4Location4Mo25:24:0026:00:00361114.50
Program5Location5Fr20:00:0023:00:001802

104.00

 

ABC2 tab should have only ABC2 in addition.

 

ProgramLocationWeekdayStart TimeEnd TimeDurationFreqABC2
Program1Location1Mo18:00:0018:30:0030884.60
Program2Location2Tu18:00:0018:30:00301787.60
Program3Location3We02:00:0003:00:00581366.90
Program4Location4Mo25:24:0026:00:0036186.70
Program5Location5Fr20:00:0023:00:001802144.90

 

Is there a way to do it in Alteryx?

3 REPLIES 3
NicoleJohnson
ACE Emeritus
ACE Emeritus

See attached! If you Transpose the data first so that all the ABC's are in one column with their respective values next to them, you can then indicate in your Output tool that you want to create a new tab for each ABC value. Just check the box at the bottom of the configuration for the Output tool and indicate Change File/Table Name based on the value in the Name column in your data.

 

Does that help point you in the right direction?

 

Cheers,

NJ

Saravanakumar
7 - Meteor

Thanks Nicole. It worked perfectly.

 

Is it possible to sort the ABC# columns in each tab after exporting within the same workflow? 

Saravanakumar
7 - Meteor

Figured out a way to sort. Applied sort before export. Thank you.

Labels