You’re offline. This is a read only version of the page.
103
Howdy,
So I have an excel file with a few hundred rows and a bunch of columns.
Its being synced to a third party vendor every two hours and my question is how to do this in the most effective way.
I created a simple "List rows present in a table" and then just updated rows in the target file.
I guess this will push/overwrite the data in the target file even if its already the same value?
Is there a good method I can apply that checks whether or not the value in the target file is the same, then skip. if not the same then it should update/overwrite?
I guess this will be more efficient and could save both resources and time - but my idea is also that if a value in some of the columns are updated it should be published in a Teams chat as well.
thanks!
Hey @fiddlerx
Not sure the best, but you can count the number of rows in both the excel files. If they are equal then in if yes you can keep it empty, and if no you can add the new items.
Share
Report
All responses (
Answers (
