topic Re: Challenge in Creating a new field as like SECTION ACCESS field in same table in App Development

Challenge in Creating a new field as like SECTION ACCESS field in same table

pradeep92 — Sat, 16 Nov 2024 19:46:04 GMT

Hi ,

I have a table like below,

TEST_TABLE:
load Shipment_ID,gc_cd as COMPANYKEY,Port_Name,gc_cd as "DGF Company" Inline [

Shipment_ID, gc_cd,Port_Name

S1900012144,AE0,Dubai

S1900323233,DE0,German

S1323243243,IN0,India
S1323243243,SG0,Singaporre

];

LinkTable:
load rowno() as ID,COMPANYKEY,Shipment_ID resident TEST_TABLE;
DROP field COMPANYKEY from TEST_TABLE;

Now i have given the section access on COMPANY KEY and it is working fine without DGF Company field.

But when I pull the DGF Company code into the table box, I could see that the below screenshot.

I should have only one record (only record with DGF Company=IN0) but it shows 2 . how to write the code accordingly.

pradeep92 — Wed, 25 Dec 2019 05:47:54 GMT

hi,

Any responses would be great! I am still facing this issue.

Anil_Babu_Samineni — Wed, 25 Dec 2019 07:53:14 GMT

Can you please share the section access script?

pradeep92 — Wed, 25 Dec 2019 13:14:41 GMT

Hi Anil,

Thank you for your response.

The script is as follows,

Load ACCESS,

NTNAME,

USERNAME,

COMPANYKEY

from Sectionaccess.xlsx;

Thanks,

Pradeep