Make the inline table of the three rows and then concate that table with the your excelsource table.
The script will be as follows:
Load * from [Excelsource];
Load * inline [
Hope this helps.
If you don't know upfront which lines are missing, you could create a table with all possible combinations for Product/Country, Year and Quartal. Then join this table to your read in data and fill in the missing zeros.
Maybe like this (I create some dummy data first, since I can't easily copy your sample data from the bitmap image):
//Create some sample data
chr(65+floor(RAND()*4)) as Product,
chr(65+floor(RAND()*4)) as Country,
ceil(RAND()*4) as Quarter,
2011+floor(RAND()*2) as Year,
ceil(RAND()*100) as Value
//Create a table with all possible combinations
LOAD distinct Product, Country resident INPUT;
join (PRODUCTCOUNTRY) load Distinct Year resident INPUT;
join (PRODUCTCOUNTRY) load Distinct Quarter Resident INPUT;
//join the created table with the original data
left join (PRODUCTCOUNTRY) load * Resident INPUT;
drop table INPUT;
// fill in missing zeros
noconcatenate LOAD Product, Country, Year, Quarter, if(len(Value),Value,0) as Value Resident PRODUCTCOUNTRY order by Product, Country, Year, Quarter;
drop table PRODUCTCOUNTRY;