MASKED DATA CALCULATION

[aj0031724]

Team,

There is a requirement to show masked data when user doe snot have the valid priviliges instead of actual data.

Maksing is done with  asterisk "*''  deending on number of digits to masked  required by user.

now the real problem comes when I want to show count of x based on  masked data .

Here count comes correct for actual data as all are unique but count gets wrong when done by Masked data as because it is getting clubbed together with similar pattern of data.

For example:

actual data ---count of x is 8

1) 12345

2)12389

3)12378

Masked data representation of above is where last 2 digits have been masked:

1) 123**

2)123**

3)123**

Now as here masked data become same for all actal data here count comes in TOTAL rather than individual  I am getting only one row with 123** with count of x as 24(8+8+8). which is wrong.

we are using straight table .

Please let me know how can I show the correct  count for masked data as well.

[marcus_sommer]

You could load this field twice - one with your masked logic and one with autonumber(OriginField) as FieldForCounter. But are the data real confidental you should use section access.

- Marcus

[MarcoWedel]

Hi,

one solution could be also:

table1:
LOAD Ceil(Rand()*200)+12300 as [actual data]
AutoGenerate 1000;

Left Join
LOAD [actual data],
    Dual(Left([actual data],Len([actual data])-2)&'**',AutoNumber([actual data])) as [masked data]
Resident table1
Order By [actual data];

hope this helps

regards

Marco

[aj0031724 · Accepted solution]

Thanks Marcus.

[aj0031724]

Thanks Marco ,I have implemented the logic and it worked.

Many thanks for the sample  qvw and code logic.

[MarcoWedel]

you're welcome

please close your thread by selecting a correct answer.

thanks

regards

Marco