Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 t...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.