Get link value from Section Access

[Anonymous]

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID,  LINK

ADMIN, admin, *

USER, user1, UK

USER, user2, US

USER, user1, SPAIN

];

SECTION APPLICATION;

DATA:

LOAD * INLINE [

COUNTRY, SALES,LINK

USA1, 150,US

United Kingdom, 250,UK

Spain1, 350,SPAIN

India1, 350,INDIA

];

From the above data the section access and section application is linked by LINK column.

Is it possible to get the LINK value.

For e.g. When "user1" access then the LINK UK,SPAIN can set to loaded to another table/variable.

[rwunderlich]

=concat(DISTINCT LINK, ,',')

-Rob

[Anonymous]

Thanks for reply.

One question, Can I use this as follows in script

I need that if the LINK value matches in resident Table2 then show value else show '*'. Means I need to display all the records in resident Table2, but LINK column should display '*" where it does not matches with =concat(DISTINCT LINK, ',')

Noconcatenate

Table1:

LOAD

FirstName,

LastName,

Link

resident Table2

[rwunderlich]

You  can't do this kind of matching in script because the LINK value is set per user at runtime.  Also, if you are using "Initial Data Reduction based on Section Access", the non-matching rows won't exist for the user.

Are you using data reduction?

-Rob

[Anonymous]

I want to display non-matching rows but the values should be '*' instead on actual value.

[rwunderlich]

Are you using "Initial Data Reduction based on Section Access"?

[Anonymous]

In my document there is following setting

Setting —> Document Properties -> Opening tab -> “Initial data reduction Based on Section Access” and “Strict Exclusion”.

Both “Initial data reduction Based on Section Access” and “Strict Exclusion” are checked

[rwunderlich]

When using “Initial data reduction Based on Section Access” non-matching rows are removed from the data. So in your original example, the row

India1, 350,INDIA

simply does not exist for user1. There is no way to display it.

What you can do is load "*" versions of the rows and link those with the LINK key the user has. That's an interesting approach I haven't tried.

-Rob

[Anonymous]

=concat(DISTINCT LINK ,',')

is it possible to create the Mapping table (inline) from the above statement in script