Forum Discussion

iLikeAzureSQL's avatar
iLikeAzureSQL
Icon for Helper I rankHelper I
7 years ago

Append Data to existing table

HI everyone,  I'm loading data from Web Data soruce into a table called LOADTABLE, I need to maintain the hsotorical loads into another table like MYDATA and append data into this table everytime I ...
Need Help
iLikeAzureSQL's avatar
iLikeAzureSQL
Icon for Helper I rankHelper I
7 years ago

I'm not following you! 

I need to connect to Web Data source ( like https://finance.yahoo.com/quote/MSFT) and grab a table and store in a table, the next time I refresh I need to grab new data and append to previously collected records with a timestamp, soemthing like building a qutoa collections over the time.

 

-Pat

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi iLikeAzureSQL ,

 

I would suggest you try the Folder connector. You can store the new table in a folder. You will get all the data combined when you refresh the report.

 

 

Best Regards,