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;
