Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi,
Any responses would be great! I am still facing this issue.
Can you please share the section access script?
Hi Anil,
Thank you for your response.
The script is as follows,
Load ACCESS,
NTNAME,
USERNAME,
COMPANYKEY
from Sectionaccess.xlsx;
Thanks,
Pradeep