it turns out that I have a comparison of 2 excel files resulting from a database query (Excel A) and another excel that extracts the data from a website (Excel B), those 2 excel are compared and the results of those comparisons are shown in a third excel document (Excel C).
The conditions are:
- if both cells are the same, do not copy the contents of the row and move on to the next one.
- If they are different, copy the contents of Excel B in Excel C
So far so good …
The condition that gives me problems is the following
- When the Excel B record is empty, this is either a space, a comma or another character that is not valid. in an Excel C column you must write that the record does not exist. how do I do that?
attach images of the information of the excel’s and the flow in UIPATH
[Excel C] how should I get out