Section access based on fact data

[SunilChauhan]

Hi all,

Hope you all doing good!

I have below scnario

Table1:

ID1 ,Dept

  1   ,   Corp

table2:

ID2,Dept

1,Corp

after concatinating above Two tables i have data like below

ID1 ,Corp ,ID2  Corptable1,Corptable2

1,Corp,Blank  ,Corp  ,Blank

Blank,Corp,1,Blank,Corp

I doing section access on Corp field

which is working good but when i select Corp in dept field

fro table one  Dept have two values

Dept

Corp

Blank

and same for table 2.

My requirement is if i give section access for Dept=Corp

then Corp should be in dept in first and second table not blank.

required your valuable help on this.

above example is for two table but i have 6-7 table with same situation please suggest.

Thanks

Sunil

[SunilChauhan]

any reply on this please?

[hubertdudek]

are you using data reduction option for document/server ? it will remove unnecessary data