Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Decrypt a encrypted field

Hi all..

does anyone know how to  decrypt a encrypted field by the value of ((+34)-1345)/245 at script level

Example:

N = ((Encrypted N +34)-1345)/245

Your Response will highly appreciated .

Thanks

Regards

RHS

7 Replies
sunny_talwar

The calculation above is how you encrypted it?

Not applicable
Author

no Encrypted N could be any value

sunny_talwar

Would you be able to share a sample with your expected output here?

Not applicable
Author

suppose N = 2345678067

     so i need when ((2345678067 +34)-1345)/245

      now the result is  9574191

so my question, is this possible at script level ???

Peter_Cammaert
Partner - Champion III
Partner - Champion III

So actually you mean:

Encrypted N = ((N +34)-1345)/245

By performing the reverse operation? Although for many values you may not be able to reverse the process as calculations in R are bound to loose some information. Do you plan to calculate with a pair of values (quotient/remainder)?

sunny_talwar

Sure thing, May be this:

LOAD N,

          ((N+34) - 1345)/245 as Decrypt

From Source;

Try this script for a sample (You might need a round() function for Rounding it to an integer)

Table:

LOAD N,

  Round(((N+34) - 1345)/245) as Decrypt

Inline [

N

2345678067

];


Capture.PNG

Not applicable
Author

Thank you Sunny T

if the value  N with braces  [2345678067

which comes from the source  so what should i do then ??