Dynamic rename Input files when processed?

Hi

Ive been googeling without luck.

Every month i get lets say 50 invoice specifications from a carrier.
They come between the 1 and the 15.

So when i run the flow, i wanna rename the input file to processed - so i can exclude processed files in the inport.

But im not sure how to do this?

Of if this is even the smartest solution?

Best Practices

Accepted answers

DavidP

Here's an example of renaming a file from Alteryx with the Run Batch Command.

It renames a file called oldfile,xlsx in C:\Test to newfile.xlsx

rename with Run Command.png

rename with Run Batch Command example.yxmd

All comments

DavidP

You could do this with the Rub Batch Command Tool.

You can write a small (DOS) batch file to rename the file and execute the batch file with the Run Batch Command Tool

afv2688

Hello @Hamder83,

There are two ways to go with this. Either you could rename the file as you say, or you could have the files moved to a 'processed' folder.

For that, after the workflow has been processed I would run an application or leave for last in your actual workflow a run command wich would execute the process.

If you want me to make you an example let me know.

Regards

Assaf_m

Hi,

I don't believe you can rename an existing file using Alteryx but I would use the option "Output File Name as Field" and check if the current input file has been processed earlier.

RolandSchubert

Hi @Hamder83 ,

what about adding an Event to the workflow? You can use a cmd file or a command (RENAME) to rename (or move) the files in the directory.

Would that be an approach?

Best,

Roland

Jonathan-Sherman

Perhaps when you read in your invoice could you also bring in the file name? Summarise by file name in a separate branch of the workflow and output append to existing to a table, bring this table earlier in the workflow and join on file name. Records falling out of the left side of the join are invoices you've not previously processed?

Hamder83

i Robert

I have tried for a long time creating a bat file that can move the files for me.

But im clearly not good enough with my dos syntax to make one work.

cause beeing able to do this would solve a lot of issues for us, im many different aspets.

i tried something like this:

but the run command is clearly not configued correctly:

Hamder83

Hi Jonathan

That is a good idea

And it could diffently work.

But when we are done doing the monthly invoicing we move the files ( getting ready for next month ) and to be sure all files are in the summary it would make that part easiere if it had a mark as Processed?

🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703