Hello Uday Kiran,
it’s very simple. you have steps.
Just search in this forum you will find WF to read column data. adopt that WF and modify for your conditions.
Once you get column data then pass them into a string and compare with if condition.
similarly for all conditions.
Hope my inputs are useful.
Thank you for quick reply however, the file is not dynamic, I am saving it by the same file name (will be replaced everyday). Here is the detailed explanation
I download a file (Excel) which has a constant range in terms of columns (A:R)
As a first a step I need to Check column B and see if it is " change" then see what kind of change it is from each Column.
As in the attached file If Column “B” is = “Change” then start the process
then it have to check relevant columns F, G, I, J and K
if column F = “No changes” skip a sequence or skip xaml but if it has some data other than “No changes” then proceed with xaml the same way for highlighted columns.
I’m just chiming in that you might think about using a Flowchart design and use a Switch.
The idea would be to read the column, then enter the Switch and based on that value it takes a different direction.
Steps to perform (in a Flowchart) would be like this:
Read Range to dt variable
Use Sequence as start of loop that does…
Assign rowcount = rowcount+1
Assign value = dt.Rows(rowcount).Item(1).ToString
Enter a Switch to go off in different directions
- Condition is value.ToUpper
- Change the text for each Case on the pathway to the Upper case of each value, such as “CHANGE EMAIL”, “CHANGE PROPERTY”, CHANGE REGION", etc
Create steps or workflows to invoke for each pathway that can also at some point connect back together for similar steps
At the end of the steps, direct the line back to the start of the loop Sequence that does rowcount+1
This is just a cool idea for designing the logic you were mentioning. The way the switch works is it looks at the value you stored and if it equals one of the paths it goes that direction; if it doesn’t equal any of the paths it goes to whichever path is the selected as the Default path.
Due to shortage of time, I cannot supply an example.