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

[pradeep92]

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]

hi,

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

[Anil_Babu_Samineni]

Can you please share the section access script?

[pradeep92]

Hi Anil,

Thank you for your response.

The script is as follows,

Load ACCESS,

NTNAME,

USERNAME,

COMPANYKEY

from Sectionaccess.xlsx;

Thanks,

Pradeep