Look up information in a table; If you do not have the information, go to another stream

look up information in a table; If you do not have the information, go to another stream.

Fine
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
Not String.IsNullOrEmpty(str_output.ToString)
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
Cheers @BrunoAmorim17

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
@BrunoAmorim17

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
row(“yourcolumnname”).ToString.Equals(“Approved”)
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

Cheers @BrunoAmorim17

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
@BrunoAmorim17

I made the following flow but he’s not making the right decision

I made the following flow but he’s not making the right decision

1 Like

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
row(“Column-8”).ToString.Equals(“Bruno”)
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
Cheers @BrunoAmorim17

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

1 Like

yah same
inside the FOR EACH ROW LOOP have these in sequence
–GET ROW ITEM activity
–WRITE LINE activity
–IF condition with condition like this
row(“Column-8”).ToString.Equals(“Bruno”)
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
@BrunoAmorim17

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?

não :slight_smile: