Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Singh
Contributor III
Contributor III

Changing same field value in multiple tables using loop

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 

 

0 Replies