Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
loading multiple qvd's from qvd folder using wildcard load at qvd path.
storing data into day wise qvd's and one field added in yesterday qvd.
" digital_campaign_code " field added in yesterday's qvd and values not reflecting.
thanks in Advance
below is my script :
Activation_Temp:
Load
'' as SupplementaryFlag,
'' as UploadDocumentFlag,
'' as ApproverUserID,
'' as ApprovalRemarks,
'' as ApprovalJustification,
'' as ApprovalStatus,
'' as digital_campaign_code
AutoGenerate 0;
Concatenate(Activation_Temp)
Load
OrderActionID,
PackType,
SimSerialNumber,
MNPInd,
DonorOperator,
PortinStatus,
PortInReason,
ActRejectReason,
ActDeviceName,
ActDeviceBrand,
ActDeviceModel,
ActDeviceSIMType,
ActDeviceColor,
ActDeviceSKU,
ActPreToPostInd,
ContractName,
ContractDuration,
ContractStartDate,
ContractEndDate
//digital_campaign_code //new
FROM
$(vQVDfolder)/OrderActivationDtl/OrderActivationDtl*.qvd(qvd);
NoConcatenate
OrderActDtl:
LOAD OrderActionID,
PackType,
SimSerialNumber,
MNPInd,
If(MNPInd=1, 'MNP') as MNPIndVal,
DonorOperator,
PortinStatus,
PortInReason,
ActRejectReason,
ActDeviceName,
ActDeviceBrand,
ActDeviceModel,
ActDeviceSIMType,
ActDeviceColor,
ActDeviceSKU,
ActPreToPostInd,
ContractName,
ContractDuration,
ContractStartDate,
ContractEndDate,
SupplementaryFlag, //NEW
UploadDocumentFlag, //NEW
ApproverUserID, //NEW
ApprovalRemarks, //NEW
ApprovalJustification, //NEW
ApprovalStatus, //NEW
digital_campaign_code //new
resident Activation_Temp;
// FROM
//$(vQVDfolder)\OrderActivationDtl\OrderActivationDtl*.qvd(qvd);
drop table Activation_Temp;
exit Script;