Hi All,
i have data in website, but it is not fixed, colums will be same but row might be changed.
img for reference
if i click on 118, it will have 118 values means 11 column and rest is row
how achieve this?
Hi @Anil_G ,
i really appreciate the way you response, thank you so much.
it is related to my previous thread actually, once we are clicking on count na using get attribute, so it can be any number for different different organization.
now, suppose BOT has iterate the excel file and took the first value as Autralia and it will click on 12(Count column), after that it will some data to scrape, means it will have 12 rows and 11 column and i need to extact the value.
similarly when 2nd time if it fetch the belgium for example and click on 17 it will have 17 item to scrape, so how to extract data, if it has different different row.
Thanks
Rakesh
1 Like
Are the columns same? And is the structure same? If yes then you can use extract table inside a loop and that should work…
Just make sure the selector is same across try to keep it generic …remove any details reated to a single table…
Cheers
yes, column are same, but some have data some doesn’t, so that it ok.
img reference for data to be extarcted
what does that mean - remove any details reated to a single table…?
Thanks
Rakesh
When you do table scrapping it would try to automaticaly extract a selector check the selector and make it dynamic to work with any table of similar type…
If data is not present then ideally it would give emoty rows or might throw error …check what is happening and handle accordingly
Cheers
ok got it,
now selector looks staright forward here
can you pls help me to make the selector dynamic? table row is changing
Also, want to scrape the data with headers. but not scrapping headers.
Thanks
May I know what are these two type of selectors…
Ideally try selecting something common between multiple tables…do some analysis on that…tag slooks similar…dont use css selector…tablerow is changing if you can find a logic with the number you are clicking use it or avoid that…try finding a class or something which is similar across
Cheers
the second img is a slector generated when i extaacted different organization data.
i extarcted data of three different org. and saw that selector is almost similar and i just check class attribute.
Try not using css selector…But it looks fine…try using this selector and extract
cheers
suppose, i have this stable selector
which attribute i should make dynamic and how. can you pls assist with Dynamic selector?
For table nothing would be dynamic…ideally unless you are seeing somethign is changing and you have the logic of how it is changing
cheers
ok, thanks.
but i need to design a code such that when BOT goes to second iteration and extarct the data, it should store it in new sheet. the first extarcted item is stored like below
now to store it in another sheet with company name, say if bot is extarcted the data for ABC it should create the sheet with ABC and write the data.
Thanks
Then instead of sheetname use a variable which contains that abc or so…mostly i beleive it is currentrow("Org").ToString
Cheers
You have the error message already…remove those characters from sheetname…use replace activity
cheers
ok, is ist because of this?
i want to take the character till Australia
Yes use currentrow("Org").ToString.Split({"/"},StringSplitOptions.None)(0)
cheers
Hi @Anil,
sorry for the late reply,
yes, it is working fine, but there is slight change in requirement. i am sorry i am adding everything in same thread.
should i create another thread? actually it is related to same automation only.
Thank you
Rakesh
If its related to web scrapping of same table continue here else better open a new Topic…
It maintains segregation of topics. You can close this if done
cheers