topic Section Access not working in App Development

Section Access not working

suhascool1 — Mon, 04 Mar 2024 11:05:21 GMT

Hi,

I have two table order details and client details.

Order details

Client Code	Client Name	Material code	Material Name	Salesman
1200	ABC	560.334	Apple	Rahul
1400	XYZ	6033.23	Banana	Zubain
2300	PQR	453.554	Orange	Sonu

Client Details

Client Code	Salesman
1200	Rahul
1400	Zubain
2300	Sonu

How can see Salesman his own data not other salesman

Eg: Rahul Salesman can see his own data.

Client Code	Client Name	Material code	Material Name	Salesman
1200	ABC	560.334	Apple	Rahul

i have written this code.

SECTION ACCESS;
SA:
NOCONCATENATE
LOAD
"ACCESS",
Upper(USERID) as USERID,
"SALESMAN"
FROM [lib://Section Access Files/India/test.xlsx]
(ooxml, embedded labels, table is Sheet1);

Re: Section Access not working

Antoine04 — Mon, 04 Mar 2024 11:08:46 GMT

Hello,

I do think that all the values used in section access need to be in capital letters.

So not "Rahul" but "RAHUL"

Regards,

Antoine

Re: Section Access not working

suhascool1 — Mon, 04 Mar 2024 11:19:15 GMT

Hi,

This is my Section access file data.

ACCESS	USERID	SALESMAN
USER	TEST\RAHUL	Rahul

Re: Section Access not working

suhascool1 — Mon, 04 Mar 2024 11:39:04 GMT

it is not working.

Re: Section Access not working

martinpohl — Mon, 04 Mar 2024 11:49:38 GMT

as mentioned, you have to use upper letters

See help

All the field names and field values listed in Section Access are always converted to uppercase. As a result, all fields that are part of a data reduction must be converted to upper case to match what is stated in the Section Access statement, even if they are located outside the Section Access Statement. You can convert any field name containing lowercase letters in the database to uppercase using the Upper function before reading the field by the LOAD or SELECT statement.

Regards

Re: Section Access not working

anat — Mon, 04 Mar 2024 12:26:46 GMT

SECTION ACCESS;
SA:
NOCONCATENATE
LOAD
"ACCESS",
Upper(USERID) as USERID,
upper(SALESMAN) as SALESMAN
FROM [lib://Section Access Files/India/test.xlsx]
(ooxml, embedded labels, table is Sheet1);

Section Application:

load

[Client Code], [Client Name], [Material code], [Material Name],upper(Salesman) as SALESMAN

from source;

Re: Section Access not working

Dataintellinalytics — Mon, 04 Mar 2024 14:05:36 GMT

Refer to below Section Access Implementation video, it might help. As already pointed by others Both field name and content should be in CAPS.

https://youtu.be/Ni2y04BwV6o

Re: Section Access not working

suhascool1 — Tue, 05 Mar 2024 06:40:24 GMT

Thank you Anant