Occurence of number in scraped data

Help
1

Hi,

I have a scraped data in below format.These numbers changes everytime.I want the integer of high occurence
as a result.How can i achieve it.
input:
500 1000 1000
500 30000 30000
27000 27000 27000
ouput:27000

2

Hi @ranjani
Please see the attached workflow where after counting occurrence for each unique record from your input data, each count result was added to a list, then a maximum result was found (the highest occurrence), and every record with this highest occurrence was then displayed (for a test I have added additional “30000” to see what happens if more than one record has the highest position). The screenshot with the lower part of the workflow shows that the output was correct… Does this solve your issue? :slight_smile:
count occurrence.xaml (13.1 KB)

countoccurrence
countoccurrence1472Ă—976 119 KB

1 Like
3

Thanks for your help

4

No problem :slight_smile:

5

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