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

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

Tue, 17 Apr 2012 16:23:46 GMT

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

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

Thu, 21 Jun 2012 11:59:00 GMT

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;