How do I create a counter field for product IDs

[Folarin]

Hi,

How do I create a counter field for product IDs?

[petter · Accepted solution]

In your load script in a load statement you could use the AutoNumber() function:

LOAD
    AutoNumber(ProductID,'ProdIdCounter') AS ProuctIdCount,
    ....

[Folarin]

can you also use a flag? If true, how

[petter]

Yes you can use flags just like any type of analytics tool... But how and where you create it depends on the data model and how you want to use the flag later on in your expressions and your analysis.

[ NOTE: to show any contributor that you like and appreciate their answers please CLICK the like icon (thumbs up) ]