Power Query Specialist to Edit Code
£10-20 GBP
Paid on delivery
ONLY REPLY IF YOU HAVE EXPERTISE WITH POWER QUERY and M programming language in Excel and can do this job within 2-3 hours. PLEASE ALSO LOOK AT ATTACHED FILE AND PROJECT DESCRIPTION TO MAKE SURE YOU UNDERSTAND TASK.
I have created the attached basic spreadsheet. In summary, if I enter a url in column A from the website [url removed, login to view], refresh the table in D:G, it will scrape the data from the page. However, if you go to [url removed, login to view] it will briefly show "no markets available". This is sometimes scrapped and the data will be blank. And I can't figure out a way to fix this!! So that's what I need help with.
It could be as simple as IF first row is "no markets available" THEN refresh feed again UNTIL first row <> "no markets available". But I'm really new to power query so don't really know how to do that! Have found this on google [url removed, login to view] but can't really find much more help.
I tried invokeafter but couldn't get that to work so have put the time delay back to 0 secs. You will see an example of an individual feed on Sheet2 as well.
So all I need is that small bit of code written. Ideally within 2-3 hours of this posting
Thanks
Project ID: #15014058
About the project
Awarded to:
Hello I am highly interested to do your project . I am able to refresh this with your full satisfaction . I am confident about the work . Relevant Skills and Experience 5 Proposed Milestones £18 GBP - I can do it sir
