Multiple condition

Help Activities
, ,
1

Hi Guys, @amaresan @KarthikByggari
I am stuck in multiple conditions. I need assist with following requirements.

Input file 1.xlsx:
image

Input File 2.xlsx:
image

Requirements:
under nested for each row—
row1(“currency”).ToString =row2(6).ToString and row1(“E Type”).ToString.Trim=“BC Type”
Print: BC Type column first row based on ABC Type column.
2nd condition:
row1(“currency”).ToString =row2(“ABC Type”).ToString and row1(“E Type”).ToString.Trim=“BD Type”
Print: BD Type column first row based on ABC Type column.

Please share your better suggestion for match requirements
if currency = usd and E Type = BC Type then check 2nd excel file where column ABC type and BC Type column.
if currency = EUR and E Type = BC Type then check 2nd excel file where column ABC type and BC Type column.
Print respective value based on ABC Type column
if currency = EUR and E Type = BON Type then check 2nd excel file where column ABC type and BON Type column.
Print respective value based on ABC Type column
and so on…
Please someone help me switch or if or other functionality which is best for this.

Any help will appreciated.

2

Hi @exclusive_raz

Welcome to UiPath Forum.

Please find the below screen shot for your reference. Try this and let me know whether it meet’s you expectation.

image
image710×1064 22.1 KB

In “Write Line” activity, please provide like this- row2(row1(“E Type”).ToString).ToString

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

3

Hey @vignesh.ks
Thank you for reach me. I have did what ever you have showed.
In your if else there is multiple match criteria.
Like 1st match do something
2nd match do something
3rd match do something
4th match do something
and so on.

What is the best way to do that if or switch or other functionality?
Please make reference for this

Thank you

4

@exclusive_raz You can use switch activity for this scenario.

Please find the below screen shot for your reference.

image
image763×1452 34.3 KB

Thanks.