Import from Web Page and Create Database

[danialsj]

I am trying to maintain a database of a stock website that updates on a daily basis. I import data through 'Import from web page' and then transform the data based on my needs. 

The problem I'm facing is that I'm trying to create a record of the imported data. For example, when I refresh the data today, I will get todays data store in a master table. When I refresh the data tomorow, tomorow's data gets imported and stored into the master table without replacing the previous days data. This way I want to create a master database of the website that I will referesh on a daily basis. 

So far I have tried appending the table as new but the table gets replaced with new data and doesn't store the previous one.

Is this possible?

I'm importing data from https://www.ksestocks.com/MarketSummary 

[PhilipTreacy]

Hi @danialsj 

No you can't do that in PQ.  When PQ refreshes a query it gets the latest data available and anything it had previously imported gets overwritten.

Regards

Phil