[Expression.Error] When refreshing table with new info

[ryansm05]

File link: Gofile

Hi,

I am pulling in 10 tables from William Hill (bookmakers) with all the English Premier League anytime goalscorer odds.

Part of this process includes tweaking the data in the 'edit' mode which I've detailed below. However, when the gameweek is over, the tables are updated by William Hill with new information e.g completely different fixtures - but when trying to manually refresh and bring this new data through I am greeted with an error message.

Error example: [Expression.Error] The column 'Goalscorer Markets - Newcastle v Everton' of the table wasn't found

Changes I'm making in 'Edit' mode:
1) Rename all columns
2) Remove top two columns
3) Remove various columns
4) Add a unique text for each table (table 0, table 1, table 2 etc)

Any help would be much appreciated as I'm completely new to Query.

Thanks
Ryan

 

[ryansm05]

bump?

 

[sandy666]

Gofile - Free Unlimited File Sharing and Storage

Gofile is a free, secure file sharing and storage platform. With unlimited bandwidth and storage, you can easily store and share files of any type without any limits. Our advanced features, such as CDN support and password protection, make Gofile the ideal choice for individuals and businesses...

gofile.io