Structure of Loops

Batch_Data_ASOS_June.xlsx (38.9 KB)

@NIVED_NAMBIAR @GBK @Pradeep_Shiv can you please help

1 Like

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
2 Likes

can you please explain in the uipath format?

Thanks
Chethan P

1 Like

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 :grin:

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

2 Likes

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
image

when i open ur xaml file @copy_writes

1 Like

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.

WelCome_mail in ChatBot.zip (22.0 KB)

Hi @Yudhisteer_Chintaram1

did u tried the concept which i had sent ?

image

What is data_1 and data_2 please?

Can you explain me this step too please?

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

2 Likes

I am working on it right now. I will let you know in a moment.

Thanks!

1 Like

Hi @NIVED_NAMBIAR ,

You saved my life!!! Thanks a lot man. It’s awesome! Perfect.
God bless.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.