I have more than 5 files that is possible to have different headers. I am able to locate the folder and scan through each files and put the filenames in the Main tab. Attached above are the sample files. The template is the Consolidation Automation v2 and the file to be opened is the 1.csv and 2.csv.
Here is the Step by step process of the tool:
[1] scan on each file
[2] open the file
[3] delete the 2nd row
Which is already working, now I need to activate 1.csv and do the following:
[4] I have to go back to the Consolidation Automation v2 file > Data tab
[5] get the 2nd column header of the Consolidation Automation v2 file
[6] find the 2nd column header to the opened file (1.csv)
[7] copy the column data from the opened file excluding headers (Row 1)
[8] paste it back to the Consolidation Automation v2 file
[9] repeat steps 5-8 once all the headers where found, 1st column will fill up with the filename of the opened file (1.csv)
[10] then count all the lines for the file and put it in the Main Tab
[11] then repeat steps 1-10 again when moving the next file
Bookmarks