Section Access not working

[suhascool1]

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);

[Antoine04]

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

[suhascool1]

Hi,

This is my Section access file data.

ACCESS	USERID	SALESMAN
USER	TEST\RAHUL	Rahul

[suhascool1]

hi 

it is not working.

[martinpohl]

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

[anat · Accepted solution]

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;

[Dataintellinalytics]

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

[suhascool1]

Thank you Anant