I created a new flowchart that takes a saved invoice record data-table from my computer that I downloaded from an SQL query, uploads this table (93k+ rows) to UiPath and then runs through each row and tests a series of conditions on the rows to find and flag certain invoices that violate the rules. I had some questions on how i can successfully build this.
I want to create a new table consisting of the rows that violated the rules. As an example, let’s say I want to create a new table consisting of only cash transactions and with employees named C. I would attach a table but the system’s not letting me.
The example table I have looks like this.
Month Year Employee Manager Payment Type Expense Amount
1 2019 A Jeff Credit 20
2 2019 A Jeff Good Looks 26
3 2019 A Jeff Cash 18