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...