help with interactions in the files

I’m new user in Alteryx and I used to be programming in R. My question is:

I want to open a specific file from a specific folder, later I need to do a treatment to this file and save it with another name in a specific folder. For example:

Folder: 2018.02/DATA/FILE_10.xlsx

And I need to save it in the same folder but another direction:

Folder: 2018.02/ASSIGNMENT/TREATMENT_10.xlsx

As you can see it’s the same folder but different sub folders inside. Someone could help me? Because I need to do it to 5 years monthly.

Thanks.

Topic of Interest

Accepted answers

CharlieS

As long as you use the entire file path and not just the file name, everything should stay organized. if you'd like to perform this one file at a time, I suggest building this process into a batch macro that uses the full path as the control parameter.

All comments

CharlieS

Hello and welcome to Alteryx-ing!

Let's start with some basics, are you comfortable using the Input tool to read Excel files and the Output tool to write Excel files in isolated scenarios? We'll build on those skills to achieve this.

Important question: Does the subdirectory "ASSIGNMENT" already exist in the "2018.02" folder? The Output tool in Alteryx can't create directories, so we'd have to address this another way.

Fabian_Gamboa

Yes. The subdirectory already exists and it's empty. I will explain myself in detail:

1. I have plenty of directories with "dates", for example 2016.01, 2016.02, 2016.03, which are basically results by period.

2. What I need to do is open an specific one which link is "G:/BASES/SAVINGS/RESULTS/2018.02/DATA/FILE_10.txt", what I need to do is changing the period because the same File_10.txt is in every subdirectory (2018.02,2018.03).

3. After open the specific file_10.txt I need to do some treatment like changing some fields with formulas and after that I need to save it in the same directory but with another name and in a different subdirectory. "G:/BASES/SAVINGS/RESULTS/2018.02/ASSIGNMENT/ASSIGN_10.txt".

I need to do it to 60 files that have the same schema.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703