Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts!
I want to know if it possible to use data reduction in section acces by the oppossite, for example:
USER REGION
1 10,20,30,40
2 50
If i want to create an excel to reduce data, the only way is create a registry for every region to the user 1?
for example:
USER REGION
1 10
1 20
1 30
1 40
2 50
there is another way? for example, in 1 line something like <> 50?
thank you a lot
Fernando K.
if you want to use some rule in excel, you have to add the logic in the load script to change the rule to the usual format of the section access (list of accepted values or *)
example you want to exclude values
-50
the pseudo code would be
if there is a -xvalue for a field and user
the section access for the user will be all values of the fields excluding -xvalues
I think it can become quite complicated
I think your end-result for the section access needs to look like this one:
USER REGION
1 10
1 20
1 30
1 40
2 50
But you didn't need to start there. If you load such table:
USER REGION
1 10,20,30,40
2 50
with a subfield(REGION, ',') you could create the needed data-structure.
- Marcus