Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pradeep92
Partner - Creator II
Partner - Creator II

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

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.

 
Labels (1)
3 Replies
pradeep92
Partner - Creator II
Partner - Creator II
Author

hi,

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

Anil_Babu_Samineni

Can you please share the section access script?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
pradeep92
Partner - Creator II
Partner - Creator II
Author

Hi Anil,

Thank you for your response.

The script is as follows,

Load ACCESS,

NTNAME,

USERNAME,

COMPANYKEY

from Sectionaccess.xlsx;

Thanks,

Pradeep