Data Reduction by the opossite

[fkeuroglian]

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.

[maxgro]

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

[marcus_sommer]

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