Merge Every 3 Files / Data Tables in Directory

[Enrico_N_F]

I have many Excel files in directory and want to merge every 3 files there. Can you help me?

files = Array of String

After take all files from directory, im using For Each from ‘files’ to store all data tables to List of Data Tables called listOfTables.

Then i proceed to use For Each data tables in listOfTables and use IF Condition to merge every 3 data tables there. So i can store the merged data tables to new Collection called listOfMergedTables.

My question is… what is the right condition to put in the IF Activity and what Activites should i use in Then and Else section ???

PLS HELP

Main Fix - Copy (2).xaml (17.3 KB)

[Shiva_Nikhil]

@Enrico_N_F

You can try this way

arrfiles is the array of array of string datatypes

Main.xaml (10.0 KB)

[Enrico_N_F]

Appreciate it! Thank you.