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
Pseudocode:
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?
Thanks
Chethan P
Testing.xaml (16.6 KB) temparature.xlsx (8.3 KB)
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
Thanks
Chethan P
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
Thanks
Chethan P
20 columns don’t sound much so it’s weird that it would affect the performance. Have you been able to pinpoint the bottleneck?
Hi @Yudhisteer_Chintaram1
Have a look at that workflow
Main.xaml (14.0 KB)
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
Regards,
Nived N
Happy Automation
Can you please check and review my code I need to know what i did if yo dont mine
Batch_Bot (2).pdf (1.1 MB)
@NIVED_NAMBIAR @copy_writes @ptrobot Here’s the screenshots of the process flow.
Maybe you will get a better idea with this.
Yes I got these issues too.
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.
Thanks!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.