Forum Discussion
Insert a row into a table after each refresh
I have two queries say A and B. Query A has a R script that generates a single data row after some prediction calculation. The results of A need to be added into B.
Initially B is empty. After the first refresh, data is generated in Query A and it needs to be appended into Query B. Subsequently, after each refresh, all the data generated in Query A needs to list up in B.
Basically, here Query B is maintaining a log of results from Query A. How to achieve this? Let me know if any more explanantion is needed.
Hi Anonymous,
Please consider below two scenarios.
Scenario1: Query A always loads one row record. After refresh, the new record would cover over the old record.
It is not possible to insert the new record into Query B every refresh.
Scenario2: Query A has only one row record originally. Each time we refresh Query A, it would add one row record into the loaded table.
In that case, your requirement could be achieved. Please append Query A to Query B. When you refresh Query A, the new updated data would be automatically added to QueryB.
Best regards,
Yuliana Gu
3 Replies
I think that is not possible at the moment.
Hi Anonymous,
Please consider below two scenarios.
Scenario1: Query A always loads one row record. After refresh, the new record would cover over the old record.
It is not possible to insert the new record into Query B every refresh.
Scenario2: Query A has only one row record originally. Each time we refresh Query A, it would add one row record into the loaded table.
In that case, your requirement could be achieved. Please append Query A to Query B. When you refresh Query A, the new updated data would be automatically added to QueryB.
Best regards,
Yuliana Gu
v-yulgu-msft Your solution will only work first time you will have A and B time second time You will A and C and B will be missing.
