How to assign values to a range

Help Activities
1

Hi,

I have a table with the below information:

Amount Owner
0 - 5000 Ariel
5001 - 10000 Mary
10001-50000 Bader

I have a input excel file with amounts

Example : if my amount is 1250 I want to populate a field as Ariel

Please let me know how to achieve this

2

Hi @aishwarya1

You can achieve via If condition

  • Use Read range activity and store the value in the DT
  • Use For each row in DataTable - Pass the value ad DT
  • Use If activity
    Condition - Cdbl(row("Amount").tostring.trim)=1250

Then part
You can populate a field as Ariel

Else Part
You can’t populate

Regards
Gokul

1 Like
3

You can use for each row of this TableDT, And pass condition like
cdbl(Amount)>=cdbl(Currentrow(“Amount”).toString.split("-“c)(0)) and cdbl(Amount)<=cdbl(Currentrow(“Amount”).toString.split(”-"c)(1)).

Let me know if you have any query.

Regards,
Saloni

1 Like
4

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