How to showing image source link one time in excel sheet

How to?
#1

After export data Image source link showing with all author name or info . I need to show image link only one cell.

Url: https://www.thieme-connect.de/products/ejournals/issues/10.1055/s-00000041/2020

Sitemap:
{"_id":"18Thieme_Year_Wise_Issue_allinfo_Scrape","startUrl":["https://www.thieme-connect.de/products/ejournals/issues/10.1055/s-00000041/[2020-2024]"],"selectors":[{"id":"Issues","linkType":"linkFromHref","multiple":true,"parentSelectors":["_root"],"selector":"a","type":"SelectorLink"},{"id":"Article","linkType":"linkFromHref","multiple":true,"parentSelectors":["Issues"],"selector":"a.articleTitle","type":"SelectorLink"},{"id":"Author Affiliation ","multiple":true,"parentSelectors":["Article"],"selector":"span.author","type":"SelectorElement"},{"id":"Name","multiple":false,"parentSelectors":["Author Affiliation "],"regex":"","selector":"div.name","type":"SelectorText"},{"id":"Affiliation","multiple":false,"parentSelectors":["Author Affiliation "],"regex":"","selector":"_parent_","type":"SelectorText"},{"extractAttribute":"href","id":"Orcid","multiple":false,"parentSelectors":["Author Affiliation "],"selector":"a.orchid-id","type":"SelectorElementAttribute"},{"id":"Full Text","linkType":"linkFromHref","multiple":false,"parentSelectors":["Article"],"selector":".tabBar li:nth-of-type(2) a","type":"SelectorLink"},{"id":"Address For Correspondence","multiple":true,"parentSelectors":["Full Text"],"selector":"section#htmlfulltext","type":"SelectorElement"},{"id":"Correspondence Name","multiple":false,"parentSelectors":["Address For Correspondence"],"regex":"","selector":"div:nth-of-type(6)","type":"SelectorText"},{"id":"Email","multiple":true,"parentSelectors":["Address For Correspondence"],"regex":"","selector":"[href^=\"mailto\"]","type":"SelectorText"},{"id":"Department","multiple":false,"parentSelectors":["Address For Correspondence"],"regex":"","selector":"div:nth-of-type(7)","type":"SelectorText"},{"id":"link","multiple":false,"parentSelectors":["Article"],"selector":".zoomFunction img:nth-of-type(1)","type":"SelectorImage"}]}

#2

something like this...

{"_id":"18Thieme_Year_Wise_Issue_allinfo_Scrape","startUrl":["https://www.thieme-connect.de/products/ejournals/issues/10.1055/s-00000041/[2020-2024]"],"selectors":[{"id":"Issues","linkType":"linkFromHref","multiple":true,"parentSelectors":["_root"],"selector":"a","type":"SelectorLink"},{"id":"Article","linkType":"linkFromHref","multiple":true,"parentSelectors":["Issues"],"selector":"a.articleTitle","type":"SelectorLink"},{"id":"Author Affiliation ","multiple":true,"parentSelectors":["Article"],"selector":"span.author","type":"SelectorElement"},{"extractAttribute":"href","id":"img","multiple":false,"parentSelectors":["Article"],"selector":".zoomFunction","type":"SelectorElementAttribute"},{"id":"Name","multiple":false,"parentSelectors":["Author Affiliation "],"regex":"","selector":"div.name","type":"SelectorText"},{"id":"Affiliation","multiple":false,"parentSelectors":["Author Affiliation "],"regex":"","selector":"_parent_","type":"SelectorText"},{"extractAttribute":"href","id":"Orcid","multiple":false,"parentSelectors":["Author Affiliation "],"selector":"a.orchid-id","type":"SelectorElementAttribute"},{"id":"Full Text","linkType":"linkFromHref","multiple":false,"parentSelectors":["Article"],"selector":".tabBar li:nth-of-type(2) a","type":"SelectorLink"},{"id":"Address For Correspondence","multiple":true,"parentSelectors":["Full Text"],"selector":"section#htmlfulltext","type":"SelectorElement"},{"id":"Correspondence Name","multiple":false,"parentSelectors":["Address For Correspondence"],"regex":"","selector":"div:nth-of-type(6)","type":"SelectorText"},{"id":"Email","multiple":true,"parentSelectors":["Address For Correspondence"],"regex":"","selector":"[href^=\"mailto\"]","type":"SelectorText"},{"id":"Department","multiple":false,"parentSelectors":["Address For Correspondence"],"regex":"","selector":"div:nth-of-type(7)","type":"SelectorText"}]}
#3

image
image1365×643 186 KB

Is there any way print only one image url for one article link

#4

Screenshot_2
Screenshot_21365×671 350 KB

check this excel file I need image url only one for one article . But it showing 7 times

#5

that's because there are 7 varioations of Element... easy to combine this data in Excel

#6

Hi, the constant data will always repeat if there are variations over several rows.

You could rework the sitemap and create as many 'Author Affiliation' selectors as there are authors and display each in a new column, but that would unnecessarily complicate the sitemap.

1 Like