Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
amien
Specialist
Specialist

counter on SubField

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?

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Amien,

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

Regards,

Antonio

View solution in original post

1 Reply
antoniotiman
Master III
Master III

Hi Amien,

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

Regards,

Antonio

View solution in original post