how to declare the more conditions in if
example: if the column has blanks and other column has dates how to declare that in if condition
Try this. Specify if you have more conditions:
If activity:
Condition: String.IsNullOrEmpty(CurrentRow("columnname").ToString) And IsDate(CurrentRow("columnname").ToString)
Then:
// Your actions if both conditions are true
Else:
// Your actions if at least one condition is false
Hope it helps!!
Regards
in this condition i have to declare the null
i have condition like column a should have date and column b should have null
how to declare that in if condition
Could you try this condition:
If
CurrentRow("Acknowledgement Date").ToString.Contains(Now.ToString("MMMM")) AndAlso
CurrentRow("Acknowledgement Date").ToString.Contains(Now.AddMonths(-1).ToString("MMMM")) AndAlso
String.IsNullOrEmpty(CurrentRow("Vehicle Unloaded Date").ToString)
Then:
// Your actions if all conditions are true
Else:
// Your actions if at least one condition is false
Hope it helps!!
how to replace all the column values with a value by modern activity
You can use the Find/Replace Value activity to find the specific values and replace with the required values.
Hope it helps!! @anjani_priya
no it just replacing only one value but i want to replace a whole column with a value
No it replace all the values. @anjani_priya
Provide your input here or create a new post and attach the input and provide what to replace.
sheet1.xlsx (38.9 KB)
i want to replace the column with ‘xyz’
i have already created a post
which column you want to replace with xyz. Are you asking about to replace all the values in the column with xyz. @anjani_priya
in name column all the values should be replaced with xyz
Okay @anjani_priya
→ Use the read range workbook activity to read the excel and store in a datatable datatype variable, let’s call it as dt_Input.
→ After read range use the assign activity to write the below expression
- Assign -> Currentrow("name") = "xyz"
→ out of for each insert the Write range workbook activity to write the dt_Input to the same excel sheet. In the properties of Write range workbook activity check the add headers option.
Check the below workflow for better understanding,
Input -
Output -
Hope it helps!!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.