Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Actually I'm looking for a solution i.e I'm extracting data from sales-force and storing it in qvd through loop
e.x
Let vFiles = NoOfRows('Files');
SUB FullDataExtract
For i = 0 to (vFiles - 1)
LET vLoad = upper(peek('Load', $(i), 'Files'));
if vLoad = 'Y' then
LET vSourceObject = peek('Source Object', i, 'Files');
LET vStoreFile = Peek('Store File', i, 'Files');
SET vStoreFile = $(vStoreFile).qvd ;
//**************** Query full base data from Salesforce data and Store into QVD********************\\
$(vSourceObject):
LOAD *;
SELECT *
FROM $(vSourceObject);
Store $(vSourceObject) into [$(vRawDataDir)$(vStoreFile)];
Drop Table $(vSourceObject);
//**************** Query full base data from Sales-force data and Store into QVD********************\\
end if
Next i
End SUB;
So the main question is while extracting, some fields are having values in Boolean format like (false and true) which I want to convert into no and yes for Ex : field 'IsDeleted' containing false and true whereas some other fields are also having same fields so how do i change that field while saving it into qvd .
please Help me ASAP