Get the excel column row values

[Anil_Rajavarapu1 (Anil Rajavarapu)]

Hi team

I need one logic for my project

For example in excel

Column-1. Column-2. Column-3. Column-4
Sp charges inland. Nil. 4000
Sp charges import. 400. 5000
Sp charges. ladge. 500. 6000

In this data i need to check if sp charges is inland then only pick column-3 values
Other wise give exception

Please any one help me for this query

[Umadevi_Sanjeevi]

Hi @Anil_Rajavarapu1 ,

Can you try this

Input:
Column-1. Column-2. Column-3. Column-4
Sp charges inland. Nil. 4000
Sp charges import. 400. 5000
Sp charges. ladge. 500. 6000

Output
Column-1. Column-2. Column-3. Column-4. OutValue. Exception
Sp charges. inland. Nil. 4000. Nil
Sp charges. import. 400. 5000.. Exception
Sp charges. ladge. 500. 6000.. Exception

Workflow.zip (3.2 KB)

Thanks

[Anil_Rajavarapu1 (Anil Rajavarapu)]

Ok umadevi thank for your reply i will check and update

[Anil_Rajavarapu1 (Anil Rajavarapu)]

Hi umadevi the zip file is not working please resend it again

[Umadevi_Sanjeevi]

@Anil_Rajavarapu1 ,

Can you try this xaml

Main.xaml (11.9 KB)

Thanks!

[Anil_Rajavarapu1 (Anil Rajavarapu)]

No umadevi still i am facing same issue from half an hour

[Anil_Rajavarapu]

it’s working umadevi

[Umadevi_Sanjeevi]

Hi @Anil_Rajavarapu

Okay!.