Jerry Johnson
- Total activity 4
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 1
Activity overview
Latest activity by Jerry Johnson-
Jerry Johnson commented,
It turns out I that the EXPLODE_RANGE function provides the results I am looking for. It EXPLODE_RANGE(1;#Quantity). which replicate records based on Quantity number.
-
Jerry Johnson commented,
The REPT result will be repeated depending on the factor of how many items were purchased, So it could be more or less. The example I provided was when 3 were purchased.
-
Jerry Johnson created a post,
Create List off of REPT function
I am looking to create a new row based on a product being purchased 3 times in a transaction. So current record has product code with a quantity of 3 but I need each quantity on its own line/record...