Excel Automation

Hi everyone, just want to check if Kapow is capable of doing these automation in excel:

1) Remove unwanted columns,

2) followed by merging the 2 files with the columns removed 

3) Finally, Remove the duplicates from merged files.

Please advice on this issue, thanks for the help.

Hi,

I don't know if this is the best method but for this I would write the files to a database table excluding the columns you don't want to capture.
Then run a query on the database to remove the duplicates and write the clean data back into an excel.

Thanks

Hi, thanks for the quick response. Just to check is there any functions in Kapow that help remove the duplicates? Thanks

Hi Junwei,

The one of other alternative is creating small Excel VBA (you can record the VBA macro) then execute it using Device Automation.  
This will require MS Excel installed with Macro setting enabled. It will run faster than saving into DB.  

Regards,
Chris

I would like to move Row2 ColC data to be on Row1 ColC in excel before I extract the data. How can I do that? Thank you.