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.