Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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