We have two CSV files exported from two different apps on a weekly basis. We have to merge them and want to run it as schedule task.
if i do it in SQL it will look like
Select a.key1, a.first, a. last, a.key2, b.number into c where a.key2=b.key2 and a source1, b source2, c results
How can it be done with excel so we run it a a scheduled task? I all looking for a working syntax.