Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to append data from another table upon refresh?

Hi I want to append a table data with other table, where table one is refreshed with new data. So how can i append the final table with a refresh.   E.g: Table1:  Table 2:  Once the ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi venal 

 

It doesn't work. Every time the table 2 is replaced with new data and that data has to be appended to table 1. But here it happens that everytime the table 2 is replaced with new data for each day, the same data is being replaced in the table 1.

 

How can I make sure that data from table 1 is retained for previous dates? 

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Can anyone help me on this please? I'm struck over this for couple of days.

@Greg_Deckler venal @AnkitBI

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hi venal 

       

      I think you are not getting what I want, Let me explain the situation again:

       

      Table 2 runs a API call and fetches data into it for every day. When I say it fetches the data, the old data for previous days is replaced completely with new data for current date

      So Table 1 should append the data from Table 2, it should have data from previous date(coming from table 2 for previous date) and also data from current date coming from table 2. 

      As per your suggestion, it works only if both the tables have same data otherwise it doesn;t. The table 2 is replacing old data with new one , so while appending to table1 it replaces old data as well.

       

      What I wanted:

      Table 2 : -> Run a API call, fetch the data and format into the table for current date( which already done & works fine). 

      Table 1: -> Append data from Table 2 for each date and keep data for all dates. ( which I wanted to achieve - Blocked)

       

      I hope I'm clear this time.