cancel
Showing results for 
Search instead for 
Did you mean: 

Managing Elasticube Tables - How to move data from a table to another

jirazazabal
9 - Travel Pro
9 - Travel Pro

Hi all,

Sometimes, you can manage two tables in an Elasticube, one for historical data, and other for a month data. When the date goes to the next month, this accumulated monthly data needs to be copied to the historical data. The data is managed by Sisense, not the source, so you cannot use the source, and the historical table is going to be built just one time a month, when the data should be transfered from the other table (monthly data) . 

In resume, we need to copy data from one table to another (same structure). Is there a way to do that?

Thanks

1 REPLY 1

jirazazabal
9 - Travel Pro
9 - Travel Pro

Hi,

The only way I have achieved this is about using pre/post vuild plugins and exporting the data to CSVs, and then be consumed by the other cube as a CSV source there.

Best