Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hiya
this is in my main data table
Main:
type,
UPPER(type) AS TYPE_SA,
Board,
UPPER(Board) AS BOARD_SA,
"Status",
UPPER("Status") AS STATUS_SA,
UPPER(Board) & '|' & UPPER("Status") AS BOARD_STATUS_SA,
UPPER(Board) & '|' & UPPER("type") AS BOARD_TYPE_SA,
Section access
MyBridge:
LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
[BOARD_SA] &'|'& [STATUS_SA] AS BRIDGEID_SA
RESIDENT Main;
LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
[BOARD_SA] &'|<ANY>' AS BRIDGEID_SA
RESIDENT Main;
LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
'<ANY>|'& [STATUS_SA] AS BRIDGEID_SA
RESIDENT Main;
LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
'<ANY>|<ANY>' AS BRIDGEID_SA
RESIDENT Main;
******* This code works up to here
LOAD
[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA,
[BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA
RESIDENT Main;
The section access works...however I have an issue here this keeps making a circular reference...how can this be prevented?
please help
Hi,
Delete the last section
LOAD
[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA,
[BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA
RESIDENT Main;
Regards,
Hi Joanna,
the load statement
LOAD
[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA,
[BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA
RESIDENT Main;
creates an another tables, instead cant you make the table "My Bridge" have 3 columns and concatenate this data into the same table?
Hiya
I need to this code to restrict access to Type. Plus Status, and Board
I need this code to work that's my issue
Hi Joanna,
Sorry I don't understand what's your porpouse in Section Access but maybe this link can help you.
Look at dynamic
And if you like you can make a prove (to look for circular reference).
In your Original script change the last sequence for this one:
LOAD
[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA_2,
[BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA
RESIDENT Main;
Regards
Hiya
I changed it as above, it runs, but it does not work, all filter panes on sheets are, greyed out.
so I updated the data below
Main:
type,
UPPER(type) AS TYPE_SA,
Board,
UPPER(Board) AS BOARD_SA,
"Status",
UPPER("Status") AS STATUS_SA,
UPPER(Board) & '|' & UPPER("Status") AS BOARD_STATUS_SA,
UPPER(Board) & '|' & UPPER("type") AS BOARD_TYPE_SA_2,
it works again, but circular reference returns
please help
Hi Joanna,
Yo have 1 or more fields with the same Name in the 3 tables. Review it.
In the other comment I proposed this one for your understanding of circular reference:
Main:
LOAD
type,
UPPER(type) AS TYPE_SA,
Board,
UPPER(Board) AS BOARD_SA,
"Status",
UPPER("Status") AS STATUS_SA,
UPPER(Board) & '|' & UPPER("Status") AS BOARD_STATUS_SA,
UPPER(Board) & '|' & UPPER("type") AS BOARD_TYPE_SA
FROM [lib://C/listadoConsumos.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet0);
MyBridge:
LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
[BOARD_SA] &'|'& [STATUS_SA] AS BRIDGEID_SA
RESIDENT Main;
LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
[BOARD_SA] &'|<ANY>' AS BRIDGEID_SA
RESIDENT Main;
LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
'<ANY>|'& [STATUS_SA] AS BRIDGEID_SA
RESIDENT Main;
LOAD
[BOARD_SA] &'|'& [STATUS_SA] AS BOARD_STATUS_SA,
'<ANY>|<ANY>' AS BRIDGEID_SA
RESIDENT Main;
//******* This code works up to here
LOAD
[BOARD_SA] &'|'& [TYPE_SA] AS BOARD_TYPE_SA_2,
[BOARD_SA] &'|'& [TYPE_SA] AS BRIDGEID_SA
RESIDENT Main;
Regards
Hiya
I have tried renaming tables and still have no joy, only when I get a circular reference it works.
here is my security table
Security:
LOAD * INLINE [
SA_LINK,BRIDGEID_SA
ALL,*
GROUP1,NORTH|<ANY>
GROUP2,<ANY>|ORDERACTIVE
GROUP3,SOUTH|ORDERACTIVE|CATERING
] ;
//North/south is board ....Orderactive is status ....and Catering is type
please help