Forum Discussion
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
- PhilipTreacySuper User
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