I have 2 excel files and I want to update the value in Excel file #2 on basis of a where condition.(if the ID column matches in both files, then update col in file #2). I have connected to both the excels using SQL queries as I don’t want to use the Excel application scope since the files are very heavy and the read, write Range activities don’t work.
Any idea how can the update query will be structured in UiPath?
NOTE: Join datatable activity, linq queries etc. won’t work as I want to directly update the column values in the file itself; and not work with datatables.