Compare Rate and write value?

[fairymemay (noona)]

I want to read Column Count in file config.

And write in Column Sum as below. (compare Rate column FYP in file Config) —>In yellow highlight

Please guide me about it.
ConfigRate.xlsx (19.4 KB)
input18.xlsx (10.3 KB)

[fairymemay (noona)]

@Ramya_K Can you guide me for solve it ?

[Hiba_B (Hiba Beldi)]

Hi @fairymemay !

To be sure to understand, you want:

• For instance for FYP (coordinate S2), it is 508,980 and because it is between 200,000 and 1,000,000 then the sum that has to be reported from column Count to column Sum is 2.
• For instance for FYP (coordinate S3), it is 149,700 and because it is between 50,000 and 199,999 then the sum that has to be reported from column Count to column Sum is 1.

Is it ?

[fairymemay (noona)]

@Hiba_B yes

[Ramya_K]

@fairymemay ,

Loop through each row in input file and use where query to find the sum column value.

dt_Final =
dt2.AsEnumerable.where(Function(checkRow) CInt(CurrentRow(“FYP”).ToString) >= CInt(checkRow(“Min”).ToString) And CInt(CurrentRow(“FYP”).ToString) <= CInt(checkRow(“Max”).ToString)).CopyToDataTable

Hope this helps.
Filter.xaml (8.1 KB)

[Hiba_B (Hiba Beldi)]

Hi @fairymemay !
Here is another suggestion: From_count_to_sum.xaml (9.6 KB)

It uses the filter activity to do it, but basically behind the .asenumerable() that suggests @Ramya_K there is a filter in it

Let us know if we missed something !

(If you see “missing activities” that means that we are not using the same Studio version. Mine in 21.10)