swapping between infotables in javascript

[AP_9587236]

I have rows in infotable A. i have to store infotable B=A. Then i have to delete all rows in infotable A.

This have to do in a loop. How to do this?

[TonyZhang · Accepted solution]

Hi @AP_9587236,

You can use below code to clone the data of infotable A and pass it to B, then clearing infotable A:

 
let B = Resources["InfoTableFunctions"].Clone({

    t1: A /* INFOTABLE */

});

A.RemoveAllRows();

If you want to preserve the data in B and append the data A into B you can use Union service:

B = Resources["InfoTableFunctions"].Union({
    t1: B /* INFOTABLE */,
    t2: A /* INFOTABLE */
});

A.RemoveAllRows();

[AP_9587236]

While cloning, What if the B is already having rows and I want to overwrite those entries with new values of A? 

[TonyZhang]

If you assign the result of clone directly to B like below, what's inside B will be gone and be replaced by the clone of A.

 B = Resources["InfoTableFunctions"].Clone({

    t1: A /* INFOTABLE */

});