how can i interchange column values?

Question

Hi, 
 I have the following table as 
 sno product 
 -------- ----------- 
 1 product1 
 2 product2 
 3 product3 
 4 product4 
 
 I want to interchange the first two rows product sno as 2 for product1 and 1 for product2 and store the updated values in cdt again How can i do that?

Chris · Answer

To interchange the product value of index 1 and 2, you can do something such as: 
 a!localVariables(
 /* retrieve data from a!queryEntity() */
 local!data: {
 {sno: 1, product: "product1"},
 {sno: 2, product: "product2"},
 {sno: 3, product: "product3"},
 {sno: 4, product: "product4"}
 },
 
 a!forEach(
 items: local!data,
 expression: {
 sno: fv!item.sno,
 product: if(
 fv!index=1,
 local!data[2].product,
 if(
 fv!index=2,
 local!data[1].product,
 fv!item.product
 )
 )
 }
 )
)

how can i interchange column values?

Top Replies