I’m looking for a way to reformat 2 columns in my data table. One is province, the other is country. My logic so far is a for each row activity with an if statement that will iterate through the specific columns to check for the format rule.
the rule I’m trying to create is,
IF Country = “Canada” then write CAN
IF Province = “Manitoba” then write MB
IF Province = “Quebec” or QC then write PQ
IF Province = “Newfoundland” or NF then write NL
beginning: for each activity of the data table
example: decision tree iteration for country
sorry for the pseudo code, my syntax for uipath isn’t the best.