For each file in folder, rename the all files with(old name+ values from table column)

[POOJA_MARUTI_BALIGIDE (Amada)]

Hello,

Rename the files .

Old name = Payment(1).xlsx.

New name= Payment(1)-ES.xlsx
Data table values can be.
ES,BE,DE,SE,IT

[Palaniyappan (Palaniyappan P)]

Hi

How many files will be there and do u want all the files to be replaced with name from datatable

And will datatable will only one column and same number of rows equivalent to file count

@POOJA_MARUTI_BALIGIDE

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @POOJA_MARUTI_BALIGIDE ,
Can you share condition to get value data with file name?
or each file and each data row value
we can use for each file inside for each data row,
use activity rename
with newname = olname+ row(data column name).tostring

regards,

[Praveen_Mudhiraj]

HI @POOJA_MARUTI_BALIGIDE

you can try this way

output :

[POOJA_MARUTI_BALIGIDE (Amada)]

@Palaniyappan ,

The bot will go to each respective vendor portal and download the report if data report available.
When it downloads the report, the files can vary from Payment(1).xlsx,Payment(2).xlsx,Payment(3).xlsx,Payment(4).xlsx…
These files has to be renamed with Payment(1)+“-”+Country Code.xlsx
Country Code values are in DT.
Data.xlsx (9.2 KB)

[devasyasingh]

@POOJA_MARUTI_BALIGIDE Follow these steps.

==> Inside for each file in folder-

a) Get current file name.
b) LookUp DataTable to get value from DataTable (To be added in file name)
c) Concatenate current file name and Output from LookUp DataTable.
d) New file name= concatenate value (from step c)

Regards,
Dev

[POOJA_MARUTI_BALIGIDE (Amada)]

@Praveen_Mudhiraj ,

Thank you for the reply.

I want to rename all the files in folder

[POOJA_MARUTI_BALIGIDE (Amada)]

@Nguyen_Van_Luong1 ,

I have tried this solution, but the file is getting renamed with all the data table values.

EX:

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @POOJA_MARUTI_BALIGIDE ,
with each loop get only 1 row value, you can add break after rename activity
regards,

[POOJA_MARUTI_BALIGIDE (Amada)]

@devasyasingh ,

Can you provide xaml file

[Praveen_Mudhiraj]

In the excel country code as 26 rows so we need to create the 26 files ?

@POOJA_MARUTI_BALIGIDE

[POOJA_MARUTI_BALIGIDE (Amada)]

@Praveen_Mudhiraj ,

The Bot will go respective vendor portal and it downloads the report only if data is available in that portal.
For each downloaded report , It has add country code at the end.
Excel files can 20, 23 0r 26 count depend on if data available in the portal

[POOJA_MARUTI_BALIGIDE (Amada)]

@Palaniyappan ,
Any update on this?

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

hi @POOJA_MARUTI_BALIGIDE ,
my output

my input
file data

folder

my code
Rename.zip (95.9 KB)
regards,

[POOJA_MARUTI_BALIGIDE (Amada)]

@Nguyen_Van_Luong1 ,

Thank you so much, Its working as expected.

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Cheer @POOJA_MARUTI_BALIGIDE ,
Happy automation !