Discussion Board for collaboration on QlikView Scripting.
Hope someone can help me on this
I have set up incremental load
But this loads the records in a different order
I tried to rectify this (as I need to do a lastvalue)
So I tried to sort this by various order
None work. I have loaded the script below (Call_Num and FSR_Num are both numeric)
left keep (SCCall)LOAD
FSR_Call_Num as Call_Num,
etcAutoNumber (TEXT (Upper (FSR_Ser_Num)) & '/' & TEXT (UPPER (FSR_Prod_Num))) as SerialandProdNo, if (ApplyMap ('RepCodeAdj',FSR_Call_Num,'Missing')='Missing',FSR_Rep_Code, ApplyMap ('RepCodeAdj',FSR_Call_Num,'Missing')) as RepCode,
AutoNumberHash128 ( FSR_Call_Num , FSR_Ser_Num , FSR_Prod_Num) as CallSerial, //new if( NUM( ApplyMap ('WARRENDMAPP',AutoNumber ( TEXT (Upper (FSR_Ser_Num)) & '/' & TEXT (UPPER (FSR_Prod_Num))) ,'NoCode')) >
NUM( ApplyMap ('Callindate', FSR_Call_Num ,'NoCode')) ,'YES','NO') AS CallInWarr resident SCFSRTess where not Match (FSR_Employ_Num, '039') and not match (FSR_Rep_Code,'09',9) order by FSR_Call_Num ,FSR_Num //FSR_Last_Update ;
Go to Solution.
I think you have to resident load your final table (SCCall ?) another time to order it
I will try when I get to work. I have tried order by a number of times. It works at times but often I have had to find another way of doing what I wanted to.
Its possible that left keep and order by conflicts.
I eventually used
firstsortvalue (distinct FSR_Call_Num , - FSR_Num) as LastFSRNum
resident TABLE GROUP BY Call_Num;
This worked and did not need to sort
But I think the answer above (Massimo's) was correct