Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
punitpopli
Specialist
Specialist

Section Access on multiple fields in different table

Hi Experts,

I am having a requirement where i have to reduce the data bases on 2 fields which are available in 2 different table, Script looks like something below - 

T1:
Load *
,UPPER([Level 3]) as L3
, Upper(Dash) as D;
Load * Inline [
ID, Level 3, Dash
1, Upper, VI
2, lower, VI
3, midway, VI
4, ropeway, VI
5, walkway, VI
6, Danceway, VI
7, STYLEWAY, VI
];

T2:
Load *
,Upper(Dlevel3) as DL3
, Upper(Dash) as D;

Load * Inline [
ID, Dlevel3, Dash
1, Danceway, VI
2, lower, VI
3, STYLEWAY, VI
4, walkway, VI
5, ropeway, VI
6, Upper, VI
7, midway, VI
];

Section Access;

[DATA ACCESS TABLE]:

LOAD * INLINE [
ACCESS,USERID,L3,D,DL3
USER,PUNIT,STYLEWAY,VI,STYLEWAY
];

 

Can anyone please let me know how we can reduce the data based on both L3 and DL3 fields where ID and D columns are the column in both the tables

 

Thank you in advance

 

Regards,

Punit 

Labels (1)
2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Both table look very similar. Therefore I suggest to concatenate both by unifying the field-names and adding a manually source-field to be able to differentiate with it the sources. This is now not specially for your section access task else such an approach resolves many challenges in general.

- Marcus 

punitpopli
Specialist
Specialist
Author

Thank you Marcus for your reply

Will try concatenating both the tables and will validate of the section access is working as expected or not

 

 

Just FYI - T1 has a lot of columns currently compared to T2, this was just for representation