1 Reply Latest reply: Nov 22, 2016 5:08 PM by Marco Wedel RSS

    LOAD a row multiple times based on a value

    Stuart Frew

      Hi everyone,

       

      I have some data that has been grouped that I want to disaggregate on load.

       

      The data has many fields like Location,Start Year, Age Grouping, Gender. There is one field called Active Customers, most rows have the value 1; ie there are 1 x customer in that Location with that start year, age grouping, gender etc.

       

      However there are some rows with Active Customer set from 2 all the way up to 17.

       

      Can I create something load script to load the rows where active customer is >1 multiple times and created a unique row id at the same time?

       

      Any thoughts much appreciated.

       

      Thanks

      Stuart