Floder creations

Help
1

Dear Experts,

2
  1. Read excel , store in datatable.
  2. In for each row in datatable
    Put “create directory” activity.
  3. Assign path, folder path+ row(“Case #”).tostring
  4. Put another “create directory” activity.
  5. Assign path, folder path+ row(“Case #”).tostring+“/”+row(“Party Name”).tostring

Folder path - is the path where you want to create first folder

3

Hello @Vadugu

Please find attached workflow.

Sample.xaml (10.6 KB)

4

Hi @Vadugu,

Step 1: Read excel fill and keep output in datatable.
Step 2: Get list of companies from datatable
list = dt.rows.cast(of datarow).select(function(x) x(“columnname”).tostring).tolist
Step 3: Remove duplicate companies from list
list = list.Distinct
Step 4: Loop through the list and using create directory activity and pass folder path.

1 Like
5

Hi Am unable to get the data

Am i doing any mistake?

6

Hi Am unable to get the data into datatable

image
image431Ă—518 10.3 KB

Am i doing any mistake? Please suggest me…

Thanks in advance.

7

Hi,

Read names is a Read range activity I guess, it will give you a datatable output.
So you need to build a datatable if you want before calling the Excel Application Scope. Not after that.

8

You don’t need to use Build Data Table activity if you are reading input from excel sheet.

please refer attached xaml file.

Sample.xaml (10.5 KB)

9

Hey Thq so much its working…

10

Hi,

Please close this thread by accepting solution.