Using Loop to Get Order Total
Posted: September 2nd, 2021, 7:58 am
We read the multiple order records. Then use Loop to find the order total for every order.
Loop on F4201.
Loop Process
Query on F4211 to get order total
Use InserAndUpdateLoopNode To Add OrderTotal node back to loop node.
Run and Review output.
Try it yourself.
- Read Multiple Orders.png (184.41 KiB) Viewed 7143 times
- Read Multiple Orders.png (184.41 KiB) Viewed 7143 times
- Loop on F4201.png (76.31 KiB) Viewed 7143 times
- Loop on F4201.png (76.31 KiB) Viewed 7143 times
- Loop Process.png (51.77 KiB) Viewed 7143 times
- Loop Process.png (51.77 KiB) Viewed 7143 times
- Query F4211 to Get Order Total.png (165.38 KiB) Viewed 7143 times
- Query F4211 to Get Order Total.png (165.38 KiB) Viewed 7143 times
- InsertAndUpdateLoopNode.png (109.66 KiB) Viewed 7143 times
- InsertAndUpdateLoopNode.png (109.66 KiB) Viewed 7143 times
- Run And Review.png (73.07 KiB) Viewed 7143 times
- Run And Review.png (73.07 KiB) Viewed 7143 times