Batch_Data_ASOS_June.xlsx (38.9 KB)
I believe you should be able to solve it with a For Each Row loop and two boolean variables: isZeroKG and isFirstIteration
isZeroKG = True isFirstIteration = True For Each Row r in DT If (isZeroKG) Then If (isFirstIteration) Then isFirstIteration = False Else Click "Close" End If Type Into r Else Type Into r("Column 1") and r("Column 2") End If isZeroKG = Account.Equals("0kg:") Next r
can you please explain in the uipath format?
buddy i did what yo said it will compare the data using if condition
its not like your project it was related hear am compare the temp. if column 1 is not match it will go to column 2 like this
if get the solution inform me
The basic idea is that any iteration after the first is the same (but with a different row). If you look closely at the first iteration, it’s just the YES path without the Click “Close” activity. That is why we set isZeroKG to true and skip Click “Close” in the first iteration.
The rest of the pseudocode is basically in UiPath format. A few Assign activities, one For Each Row activity, two If activities and a few Type Into activities.
yes I did the same thing but I have a question if we have 20 column is there on that time what we have to do code performance is slow right
20 columns don’t sound much so it’s weird that it would affect the performance. Have you been able to pinpoint the bottleneck?
You can look at the workflow comments which i had put to get the logic how we can execute the workflow
I am preffering a while loop here to do the process
@copy_writes please have a look on that too
Can you please check and review my code I need to know what i did if yo dont mine
there is some issue with the package
when i open ur xaml file @copy_writes
Batch_Bot (2).pdf (1.1 MB)
Yes I got these issues too.
WelCome_mail in ChatBot.zip (22.0 KB)
did u tried the concept which i had sent ?
It is equivalent to Row(3)(“Column 1”) and Row(3)(“Column 2”)
So.overall logic is that when the account is zero
Then the we had to input the whole row data
So we had to make the two values Nothing so it input all rows values as per the condition
Check the if condition used below the while loop u would get to know the usage of data_1 and data_2
I am working on it right now. I will let you know in a moment.
Hi @NIVED_NAMBIAR ,
You saved my life!!! Thanks a lot man. It’s awesome! Perfect.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.