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?
Discussion posts and replies are publicly visible
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 ) ) } ) )