Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Split output into multiple files...working, but need to eliminate the split-by field

TeamTJ
8 - Asteroid

I need to split my output into multiple files.

 

I'm using the method from this thread.

 

The issue, however, is that the Tile_SequenceNum gets written to the file, even though Keep Field In Output is unchecked.

 

Suggestions?

6 REPLIES 6
LordNeilLord
15 - Aurora

Hey @TeamTJ

 

Can you screenshot your output tool config please?

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

TeamTJ
8 - Asteroid

Here you go!

LordNeilLord
15 - Aurora

Ok, no problem....

 

Add a select tool just before your output tool and deselect Tile_SequenceNum

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

TeamTJ
8 - Asteroid

That worked perfectly...thank you.

 

Did I just misunderstand the purpose of the Keep Field In Output checkbox?  I presumed it would not include that field in the output...

LordNeilLord
15 - Aurora

Hey @TeamTJ

 

No you got it correct!

 

The Tile Tool creates 2 columns, Tile_Num & Tile_SequenceNum. You're using Tile_Num to split up your file but Tile_SequenceNum remains in the output.

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

TeamTJ
8 - Asteroid

Ok, I see that now...if I leave that checked using my original method there are 2 additional fields, Tile_Num & Tile_SequenceNum.

 

I appreciate your help and that you taught me something new!

Labels
Top Solution Authors