8 Replies Latest reply: Mar 13, 2012 10:46 AM by Celambarasan Adhimulam RSS

    Generate qvd for unreleated tables

    jacq .

      Hello,

       


      // ******************Dosing ***********

      SUB Dosing(Str)

      All_$(Str):

      LOAD FieldValue('$(Str)', IterNo()) as $(Str)

      AutoGenerate(1)

      While not IsNull (FieldValue('$(Str)', IterNo()));

       

      Max_Dosing:

      LOAD  Dosing,MinDosing, MaxDosing, MinDosing as MinDosing1, MaxDosing as MaxDosing1;

      LOAD

      '$(Str)' as Dosing,

      max($(Str)) as MaxDosing,

      min($(Str)) as MinDosing

      Resident All_$(Str);

      DROP Table All_$(Str);

      ENDSUB

       

       

      CALL Dosing('DoseCavityPZ');

      CALL Dosing('DosePumpSpdS');

       

      //***************MrFreeze************************

      SUB MrFreeze(Str)

      All_$(Str):

      LOAD FieldValue('$(Str)', IterNo()) as $(Str)

      AutoGenerate(1)

      While not IsNull (FieldValue('$(Str)', IterNo()));

       

      Max_MrFreeze:

      LOAD  MrFreeze,MinMrFreeze, MaxMrFreeze, MinMrFreeze as MinMrFreeze1, MaxMrFreeze as MaxMrFreeze1;

      LOAD

      '$(Str)' as MrFreeze,

      max($(Str)) as MaxMrFreeze,

      min($(Str)) as MinMrFreeze

      Resident All_$(Str);

      DROP Table All_$(Str);

      ENDSUB

       

       

      CALL MrFreeze('MrFrzBlowTimeS');

      CALL MrFreeze('MrFrzCavityPZ');

       

      - I want to combine dosing and MrFreeze tables into one qvd file. No matter of relationship for both tables data. Instead of generating two different qvd files i want to generate single qvd file without losing data.