Link to home
Create AccountLog in
Avatar of Lia Nungaray
Lia NungarayFlag for United States of America

asked on

Automating Excel Report

I have two excel sheets, xls1 and xls2. xls1 has about 1500 rows, xls2 has about 50 or so. I need to find which records from xls2 are missing from xls1 and attach them, which is easily solved using XLOOKUP. However, I would like to automate this process using talend, python or Crystal Reports. Any ideas you can give me? 

Avatar of Ido Millet
Ido Millet
Flag of United States of America image

If you assign a named range to the data in each sheet, an ODBC DSN pointed at that excel file would treat each one as a table.

Do an outer join from xls1 to xls2 and filter to cases where a column in the outer table is null.  

Hi Lia,


can you expand a bit on the "I would like to automate this process using talend, python or Crystal Reports". What would this automation need to cover? File selection, dynamic data range, os something else? 

Avatar of Lia Nungaray

ASKER

I would have to retrieve the previous report, then run a query and compare both. Can this be done using Power BI?

ASKER CERTIFIED SOLUTION
Avatar of Noah
Noah
Flag of Singapore image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account

Going to give it a try with Talend, thanks