Forum Discussion

danialsj's avatar
danialsj
Frequent Visitor
3 years ago

Import from Web Page and Create Database

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 

 

1 Reply

  • 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