I need help with an if activity. Firstly, I have a column of data that I want to use the if activity on.
I want to put the condition so that if the number found in each row of the column of data is below 9.10, a new column will write a certain word.
You can write an assign statement to check and assign the value.
To: dtInputData.Rows(intIndex).Item(“New_Column”)
Value: if((Convert.ToDecimal(dtInputData.Rows(intIndex).Item(“Number_Column”).ToString) > 9.10), “Update text”, dtInputData.Rows(intIndex).Item(“New_Column”).ToString)
This checks whether number column value is greater than 9.10. If yes, updates the New column with the given text, otherwise, reassigns the New column value (To retain the same value if there any. Based on your requirement you can leave this blank as well).
intIndex is the index of your row.
The column does not contain any values,Can you share your workflow and excel file(or) Try to make change in this file and executeSample.xaml (9.0 KB) @jasperlzx
@jasperlzx,Sample.xaml (9.7 KB)
Modified it with your excel file,Your excel file contains headers in the second row so it was unable to find the ‘TimeIn’.Let me know if it works