Output to .csv called 'My-County-Data'
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Output to .xslx called 'Counties', name the sheet 'Sheet 1'. You must successfully run this workflow twice for it to count :)
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Output to .xslx called 'Counties2', name the sheet 'Sheet 1' by default. However, create a batch output that generates a new tab for each county (Hint: Change file name option near bottom of config) This also must run successfully twice to count :)
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Output to .xslx called 'Counties2', name the sheet 'Sheet 1' by default. However, create a batch output that generates a new tab for each county (Hint: Change file name option near bottom of config)
Remove the county data so it is not contained within the data of the sheets, but remains on the tab names
This also must run successfully twice to count :)
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Output to .csv called 'My-County-Data', but make the path relative
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Read in and write out to 2013-counties.csv immediately. Spoiler alert: you might need a 'block until done' tool to get this to work.
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Output to .csv called and create a file for each county (with the county name as the file name).
WARNING: Ensure this is pointed to a location you are comfortable landing 50+ files
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
Output Data Tool Examples
Click the triangle on the right to see the solutions.
Use the Output Data tool to achieve the target output.
C:\Users\anirudhdutt\Desktop\Anirudh'\Temp Files\My-County-Date.csv
CRLF
,
False
True
28592
True
My-County-Date.csv
C:\Users\anirudhdutt\Desktop\Anirudh'\Temp Files\Counties.xlsx|||Sheet1
False
Overwrite
Counties.xlsx
Table=Sheet1
C:\Users\anirudhdutt\Desktop\Anirudh'\Temp Files\Countries2.xlsx|||Sheet1
False
Overwrite
Suffix
Agency
Countries2.xlsx
Table=Sheet1
C:\Users\anirudhdutt\Desktop\Anirudh'\Temp Files\Countes2.xlsx|||Sheet1
False
Overwrite
Suffix
Agency
Countes2.xlsx
Table=Sheet1
_externals\1\My-County-Data.csv
CRLF
,
False
True
28591
True
My-County-Data.csv
_externals\2\2013-counties.csv
CRLF
,
False
True
28591
True
2013-counties.csv
C:\Users\anirudhdutt\Desktop\Anirudh'\Temp Files\Test.csv
CRLF
,
False
True
28591
True
FileName
Agency
Test.csv
Solutions
Output to .csv called 'My-County-Data'
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
_externals\1\My-County-Data.csv
CRLF
,
False
True
28591
True
My-County-Data.csv
Output to .xslx called 'Counties', name the sheet 'Sheet 1'. You must successfully run this workflow twice for it to count :)
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
_externals\1\Counties.xlsx|||Sheet1
False
Overwrite
Counties.xlsx
Table=Sheet1
Output to .xslx called 'Counties2', name the sheet 'Sheet 1' by default. However, create a batch output that generates a new tab for each county (Hint: Change file name option near bottom of config) This also must run successfully twice to count :)
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
_externals\1\Counties2.xlsx|||Sheet1
False
Overwrite
FileName
Agency
Counties2.xlsx
Table=Sheet1
Output to .xslx called 'Counties2', name the sheet 'Sheet 1' by default. However, create a batch output that generates a new tab for each county (Hint: Change file name option near bottom of config)
Remove the county data so it is not contained within the data of the sheets, but remains on the tab names
This also must run successfully twice to count :)
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
_externals\1\Counties2.xlsx|||Sheet1
False
Overwrite
FileName
Agency
Counties2.xlsx
Table=Sheet1
Output to .csv called 'My-County-Data', but make the path relative
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
_externals\1\My-County-Data.csv
CRLF
,
False
True
28591
True
My-County-Data.csv
Read in and write out to 2013-counties.csv immediately. Spoiler alert: you might need a 'block until done' tool to get this to work.
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
_externals\2\2013-counties.csv
CRLF
,
False
True
28591
True
2013-counties.csv
Output to .csv called and create a file for each county (with the county name as the file name).
WARNING: Ensure this is pointed to a location you are comfortable landing 50+ files
2013-counties.csv
28591
,
False
254
False
True
DoubleQuotes
1
2013-counties.csv
_externals\1\foo.csv
CRLF
,
False
True
28591
True
FileName
Agency
foo.csv
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.
Horizontal
Practice Exersice 4_solution