Section Access on multiple fields in different table

[punitpopli]

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 

[marcus_sommer]

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]

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