Naver site view page ranking display conversion

I made a logic to search for a specific keyword on, go to the view page, and then put the top post at the top of the list to get to the top 10. There, I succeeded in creating a “ranking” column and displaying the number of posts I specified there.

I want to change it like this in the current excel screen. What should I do?


Do you use DataExtraction wizard? if so, can you try the following expression using Assign just after ExtraxtTable activity?

ExtractDataTable = ExtractDataTable.AsEnumerable.Where(Function(r) Int32.TryParse(r(2).ToString.Trim,new Int32 )).CopyToDataTable

Note: this expression will throw if there is no target data.


Thank you. Have a nice day.