AnsweredAssumed Answered

convert Table 1 into Table 2 in a separate layout

Question asked by hersch on Aug 28, 2017
Latest reply on Aug 28, 2017 by hersch

I would like to convert Table 1 into Table 2 in a separate layout. I can do this by looping and set variable to transfer the data, but is there an easier way that would allow changes in Table 1 to automatically change the data in Table 2.

 

Table 1

 

T1_IDDate$ AmountAccount # Debit
Account # Credit
11/1$1,000101305
21/4$500101410
31/9$750710101
41/7$250650101

 

 

Table 2

 

T2_IDT1_IDDateAccountDebit $ AmountCredit $ Amount
111/1101$1,000
211/1305$1,000
321/4101$500
421/4410$500
531/6710$750
631/6101$750
741/7650$250
841/7101$250

Outcomes