Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I scramble data and store it in a QVD?

I want to write a script that reads an existing QVD file, scrambles some fields and then stores the QVD again.  It seems like I have a catch 22, I can scramble the data on a PostReload macro, but then how do I store it?  Is there a way to call the scramble function from the load script? Or is there a way to store a QVD from a macro?  Seems like it should be an easy task, but I am not seeing the solution.

Thanks,

john

1 Reply
Not applicable
Author

Know kind of old, but may be "Simpler" if you split the task

Have QVW1 load unscrambled QVD -> QVD_UnScrambled

Have QVW2 load the unscrambled, scramble it up, and then save as the QVD (Not unscrambled at this point)

e.g. something like:

Table1: Load * SQL Select * from Table1;

STORE Table1 INTO Table1_Unscrambled.qvd;

then in 2nd load

Load * from Table1_Unscrambled.qvd (qvd);

Scramble it up, then

STORE Table1 INTO Table1.qvd;