Directory output many .gz to many excel files?

StephenF

I have a directory full of .gz files containing one csv data file each I wish to spit them back out as xlsx files.

Best I can do is get a row of the file details printed on one sheet each in one xlsx file , what am I doing wrong?

I find this widget very unintuitive.

Help

Accepted answers

JordanB

@StephenF and myself went on a call to resolve. So for those reading the thread, the solution is outlined.

The syntax below was incorrect regarding the file extension of the file.

We needed to change this from datafile.csv.xlsx to just .xlsx|||Sheet1. This extension was added onto a re-formatted filename of schd.output_ using the text to columns tool.

We then fed these into a batch macro to allows for changing field headers.

Best,

Jordan

All comments

Claje

Hi,

You're very close!

With Excel files, "Change File/Table Name" updates the sheet name, not the actual file name itself. Alteryx thinks of excel sheets as "tables".

To output to unique files, you will need to use "Change Entire File Path" - however this will output these files to the directory your Alteryx workflow is in unless we make one more change - adding G:\FTP\sales\Samantha\DataExtracts\out\ to the "FileNameOutput" field.

You could modify your FileNameOutput formula to include this, or add a new formula tool with the following formula:

"G:\FTP\sales\Samantha\DataExtracts\out\"+FileNameOutput

StephenF

Ok I guess I have the excel files now, but they don't contain the contents of the source .gz files, just the path and filename information.

Maybe i need something else between the directory input and the output.

Maybe Dynamic Input but I dont know how to get the path/filename information into each file.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703