Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Amien,
LOAD Product&' '&IterNo(), 1 as #Counter Inline [
Product, #Counter
iPhone X, 3
Samsung 8, 2
]While Iterno() <= #Counter;
Regards,
Antonio
Hi Amien,
LOAD Product&' '&IterNo(), 1 as #Counter Inline [
Product, #Counter
iPhone X, 3
Samsung 8, 2
]While Iterno() <= #Counter;
Regards,
Antonio