counter on SubField

[amien]

I have this table loaded:

Product, #Counter

iPhone X, 3

Samsung 8, 2

Now i want to ETL this to:

Product, #Counter

iPhone X 1, 1

iPhone X 2, 1

iPhone X 3, 1

Samsung 8 1, 1

Samsung 8 2, 1

How can i do this?

[antoniotiman · Accepted solution]

Hi Amien,

LOAD Product&' '&IterNo(), 1 as #Counter Inline [
Product, #Counter
iPhone X, 3
Samsung 8, 2
]While Iterno() <= #Counter;

Regards,

Antonio