Excel row checking

Hi fnds,

pls help me
How to check value is greater than 100.00 and send mail
output req:
id 45 102.00
id 46 501.00

image

Hi
kindly have a look on to this thread
–but while using need to change few things
–in the read range mention the range as “A37” so that it would start from that row
–then replace with your columnname in the SELECT Method along assign activity

hope this would help you
kindly try this and let know for any queries or clarification
Cheers @venkateshtangudu

thanks…bro
im checking

1 Like

great
cheers @venkateshtangudu

1 Like

Book1.xlsx (9.5 KB) Main.xaml (6.1 KB)

Hi,

getting errors…cannot find the column name

here you go its working fine
filter.zip (18.1 KB)

Cheers @venkateshtangudu

1 Like

Hi
write line is not working to see the output…in the below format like
dt 45 10200

May I know what was mentioned in writeline activity
Cheers @venkateshtangudu

Hi

dt1.Tostring

That’s why
Use output datatable activity and pass the dt1 as input and get the output with a variable of type string
Then pass that string variable to writeline activity
Cheers

Hi bro,

actually i should throw exception if value is more than 100

hi
how can i split this like this and throw exception as well mail in below format
id 45 value 102.00
id 46 value 501.00

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