I am very new to UiPath and had a question about conditional if/then statements.
I have a large excel file (93,600 rows) of data. The columns are Employee Name, Manager Name, Report Submission Date (mm/dd/yyyy hh/mm/ss), Report Name, Purpose, City, Expense Type, Transaction Date (mm/dd/yyyy hh/mm/ss), vendor, payment type, personal expense, and expense amount.
I am attaching a sample of the excel sheet below.
dummy variables.xlsx (9.9 KB)
I am going to load this dataset into UiPath and then run a series of tests on this data. I want to run tests like
If Expense Type = (“Parking”) AND Expense Amount > $50
If Payment Type <> Cash AND Expense Type does not contain (“Air”)
IF report date>transaction date by 15 days
For the Then condition, I want to export these rows into a new table, then for the else condition, I want to leave the rows where they are.