Skip to main content

Announcements
Week 4: Discover ELT + ETL Strategies and Explore Predictive AI in Qlik Cloud - WATCH NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Luiper
Contributor II

duplicate records descendingly with While

Good morning, I want to double a row of the loaded base depending on the amount of a field by subtracting one unit until it reaches 1, the table is as follows:

LOAD REQ.,
ID,
[BT No.],
[Certificate No.],
Product,
[Number of installments]


I want a loaded line to be duplicated if the [Number of installments]>1 and subtract the number of installments 1 until this subtraction of this field reaches 1.

thank you
Labels (2)
0 Replies