Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

Use loop for iterating Row no

Hi 

I have one table1 (Prod_name) having fields

Prod CodeProd SubcategoryBrandProd Name

 

& the other table2 Prod_Price having fields

Prod CodeProd SubcategoryBrandPrice

 

Here key between the two table is of Prod_Code,Prod_Category & Brand

I want to make a field called Rowno which gets iterated for the same key and the counters starts once again when encountering another key. Desired output is as follows

Prod CodeProd SubcategoryBrandPriceRow No
PA1PB1L121
PA1PB1L232
PA2PB2V131
PA2PB2V132
PA2PB2V133
PA3PB3X341
PA4PB4O321
PA5PB5H171
Labels (1)
1 Reply
agni_gold
Specialist III
Specialist III

Try something like ,

AutoNumberHash256([Prod Code]&[Prod Subcategory]&Brand)