6 Replies Latest reply: Sep 6, 2012 6:10 AM by Jason Michaelides RSS

    [newbie] how to encrypt data (scrambling or randomizing)?

      Hi, I'm newbie to QlikView. I basically want that my team could load existent data (eg. CSV file) to QlikView without see the real data values inside the file.

      Is there a way to load data to QlikView and change values (not field names) at runtime? I thought:

       

      1) using Rand() function

      2) using Scrambling

       

      Can you explain me the difference between 1) and 2)  and how to apply them to the following script, eg to the Population(mio), Pop. Growth fields?

       

      LOAD Country, 
           Capital, 
           [Area(km.sq)], 
           [Population(mio)], 
           [Pop. Growth], 
           Currency, 
           Inflation, 
           [Official name of Country]
      FROM
      src\Country1.csv
      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);
      

       

      Thanks in advance