Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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.



Tags (2)
1 Reply
Not applicable

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

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;

Community Browser