look up information in a table; If you do not have the information, go to another stream.
we will be getting a output from LOOKUP DATATABLE activity right and lets name it as str_output
next to that activity use a IF condition and mention this
if this is true it will get into THEN part where we can have a sequence to work upon if the lookup gives us any value if not it will get into ELSE part where we can have another stream to work upon if the lookup doent give any value i.e., null value
hope this would help you
Hello, can we chat via Skype?
Sorry i m in travel now
no problem we can discuss here buddy
may i know what issue you were facing
I have a data table, in a specific column, I have two results “Approved” and “Enabled”.
The robot will need to read the entire column. If it finds the name “Approved”, it will continue the stream if it does not find “Approved” for another stream,
then we can simply use a IF condition without any LOOKUP DATATABLE activity involved
like once the datatable with that column is ready
use a FOR EACH ROW activity and pass that datatable as input
–inside the loop use a IF condition like this
if true it will get into THEN part where we can have one sequence of activities to be followed or it will get into ELSE part where we can have another set of activities to be followed
can I use in the decision flow?
yah of course
if you are using FLOWCHART we can use FLOW DECISION
if not is a SEQUENCE then with a IF condition
No in your case use IF condition inside the FOR EACH ROW LOOP
and remove these flow decision and message box activities on either side
–now coming back to FOR EACH ROW LOOP, inside that next to WRITE LINE ACTIVITY use a IF Condition like this
if this true it will go to THEN part where we can have a MESSAGE BOX ACTIVITY or it will go to ELSE part where we can have a MESSAGE BOX ACTIVITY
kindly try this and let know for any queries or clarification
the flow that is quite complex, create it as a test, use the decision flow
the message box is just to see if the robot is following the correct flow
inside the FOR EACH ROW LOOP have these in sequence
–GET ROW ITEM activity
–WRITE LINE activity
–IF condition with condition like this
in THEN part a MESSAGE BOX
in ELSE part a MESSAGE BOX
remove the flow decision and the message box pls and try once with the above sequence
he is reading row by row he should read the whole column at once and look for data if he can’t find go to another stream
You could just filter out the rows you dont want before the loop…
how do I do that?
Can we chat via Skype?