Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rodrigue_saade
Contributor

Section Access

Hi,

i have the following case in section access:

    

AccessUserIDPasswordRegionID
UserAUserAxx01-00-00
UserAUserAxx01-00-01
UserAUserAxx01-00-02
UserAUserAxx01-00-03
UserAUserAxx01-00-04
UserAUserAxx01-00-05
UserAUserAxx01-00-06
UserAUserAxx01-00-07
UserAUserAxx01-00-08
UserAUserAxx01-00-09
UserAUserAxx01-01-00
UserAUserAxx01-01-01
UserAUserAxx01-01-02
UserAUserAxx01-01-03
UserAUserAxx01-01-04
UserAUserAxx01-01-05
UserAUserAxx01-01-06
UserAUserAxx01-01-07
UserAUserAxx01-01-08
UserAUserAxx01-01-09
UserAUserAxx01-02-00
UserAUserAxx01-02-01
UserAUserAxx01-02-02
UserAUserAxx

01-02-03

UserAUserAxx09-09-09

Is there any way to autogenerate the values of RegionID, since the values are well defined for the same user from 01-00-00 till 09-09-09?

1 Solution

Accepted Solutions
MVP
MVP

Re: Section Access

R:

load num(rowno(), '00') as R1 AutoGenerate 9;

join (R) load num(rowno()-1, '00') as R2 AutoGenerate 10;

join (R) load num(rowno()-1, '00') as R3 AutoGenerate 10;

Left join (R) load *, text(R1 & '-' & R2 & '-' & R3) as AllRegion Resident R;

S:

LOAD Distinct

  Access,

    UserID,

    Password

FROM

[https://community.qlik.com/thread/165407]

(html, codepage is 1252, embedded labels, table is @1);

join (S) load AllRegion as Region Resident R;

DROP Table R;

4 Replies
ecolomer
Honored Contributor II

Re: Section Access

MVP
MVP

Re: Section Access

R:

load num(rowno(), '00') as R1 AutoGenerate 9;

join (R) load num(rowno()-1, '00') as R2 AutoGenerate 10;

join (R) load num(rowno()-1, '00') as R3 AutoGenerate 10;

Left join (R) load *, text(R1 & '-' & R2 & '-' & R3) as AllRegion Resident R;

S:

LOAD Distinct

  Access,

    UserID,

    Password

FROM

[https://community.qlik.com/thread/165407]

(html, codepage is 1252, embedded labels, table is @1);

join (S) load AllRegion as Region Resident R;

DROP Table R;

mov
Esteemed Contributor III

Re: Section Access

Not related to your question - but you must use REGIONID instead of RegionID if you want to use it for data reduction.

rodrigue_saade
Contributor

Re: Section Access

Solved!! Thank you Massimo, and Thank you all guys.

Community Browser