Limit Load

[Purushothaman]

Hi,

I have a QVD , I want to limit the to 600 rows based on below condition to fields;

1) Period = 2020, 2021

2) Product = Bike, Car, Cycle

 Note:  Each product 200 rows  and should be 100 rows for2020 and 100 rows for 2021.

How to do that in Data Load editior?

Anyone, Please help!!

[Aurelien_Martinez · Accepted solution]

Hi,

Peraps a script like :

for each vPeriod in '2020', '2021'

  for each vProduct in 'Bike', 'Car', 'Cycle'

    First 100

    Load * From QVD Where Period='$(vPeriod)' and Product = '$(vProduct)';

  next vProduct

next vPeriod