Move the file to respective folder using excel reference

Help Activities
, ,
1

@copy_writes
Hi I have all the files in a folder then I have created a data table added the data in to excel then I have created folders as CCode_Cname ex: (104335_TATA). Now I need to move the files in to respective folder
image

3

Is you have to read the data from the data table based on the Ccode and Cname you ahve to create a folder right

regards
Chethan P

1 Like
4

HI I can create folders need to move the C column files in to created folders based on excel columns

1 Like
5

Ok that CFile is path or data you have to store in the text

1 Like
6

C file is a pdf file move the from root folder to created respective Ccode& Cname folder

7

ok then C column contain path of the folder right

8

example as per below the file move to folder
image

9

ok can you please share the excel file I have some drought in the excel file then i will give solution for it it was easy defiantly i will give the solution for it

and change the topic feedback to reboot skill or academy learning

10

you just read the excel file and use create folder using the row i have some sample project of it i will share you in the bellow topic

It was not exact your project it just related to your project if you need the same give me some time i will give the xml file.
UipathLearer-P1.zip (7.2 KB)

11

@vijayabhaskar1987

Use For Each Row activity and inside use Path Exists activity and in that give the path of file example : D:\ + Row(“CCode”).ToString + “_” + Row(“CName”).ToString

Path Exists output True or False

Use IF Condition and place your logic

Hope this may help you

Thanks

1 Like
12

No i think he want to create folder using excel sheet data and move the file to the folder

13

@copy_writes @vijayabhaskar1987

If he wants to create the folder when that folder is not exist then why If condition

IF folder exists then no need to create the folder just move the file to the folder

Else he has to create the folder and move the file which he can keep the same in the IF condition

1 Like
14

Hi I can create Folder need only to move files However I have attached sample excel file
I will check your xaml .
Data_Tracker_16.May.2021_18.XLSX (7.8 KB)

15

@vijayabhaskar1987 - currently where the file in Column C exists? Is it all under one folder or different folder.

1 Like
16

HI under one root folder only

17

Hi @vijayabhaskar1987 ,

Loop through your Data Table and use Move File activity.

18

what he is asking am also ask the same question where its found
image

is that present in the root folder then use move file

give the correct path in side move folder simple

image

Give from and to that’s it
image

19

@vijayabhaskar1987

check below, This should in For Each row activity

image
image802Ă—952 25.5 KB

Hope this may help you

Thanks

2 Likes
20

@Srini84 for quick checking please provide xaml

21

@vijayabhaskar1987 - I would suggest to first give it a try based on the screenshot provided by @Srini84 , that way you can practice…

if you get any error or stuck then reach out to us again…

1 Like