wildcard load at qvd path

abhaskar1 — Sat, 16 Nov 2024 16:53:27 GMT

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;

topic wildcard load at qvd path in App Development

wildcard load at qvd path