[closest] Here My target number is 107 .so i want to find next closest number that is 106 .Anyone can help me out of this guys?

Hi @aruna.p5 , Could you please give little more details and describe the process?

First of all …i need to get the input value from user and then check the given value with the input file like excel sheet.If the given value matches with any value in first column ,then get that particular row .If the given value does not exist in first column ,then find the next closest number of t…

Hmmm there is many ways to achieve this. First of all you can use compare method. Keep your excel data in DataTable and compare each value provided by user with values from the first column in DataTable. If something is matching then it will throw whole row to user. If nothing is matching then you c…

@Pablito I tried few things.matching things i have done …i need to find closest number of the given value which is not exist in excel …can u please share some xaml file for logic ?

Hi @aruna.p5 , Can you please share the sample excel file i will build xaml file for u.

(Note to bystanders: I’m aware this is an incredibly inefficient way to do this, and it will be bad for huge datatables). The easiest thing you can do is: Sort datatable values (by either ascending or descending, doesn’t matter) Iterate through each row sequentially. Compare (substract) your inpu…

@aruna.p5 - You could try the “Filter Data Table” activity… Load your Excel data into data table, then use this activity to filter >= on sorted list, the your top row will be your closest match.

i dont think it will work @sagacity

closest.xlsx (10.2 KB) Here i attached the excel file @Vashisht

Take a look at this post LinQ to find closest value , this will give you an idea around how you can find the closest number using LinQ

Closest number of given value

Help

Pablito (Pawel Wozniak) August 12, 2019, 6:28am 15

Remove “project.json” file and open it from main.xaml

Topic		Replies	Views
Find the closest value in Data row Help orchestrator , studio	7	1946	May 27, 2019
I want to find the nearest value Studio activities , question , data_manipulation	24	2683	February 28, 2020
How to find the close value in data Row Help datatable , excel , activities , question	19	1708	November 20, 2019
Help for matching nearest value Something Else	2	558	December 24, 2022
How to find the closest date with the specific number Activities excel , uiautomation , studio	8	404	February 12, 2024

Closest number of given value

Related topics