topic Section Access on multiple fields in different table in App Development

Section Access on multiple fields in different table

punitpopli — Mon, 02 May 2022 14:41:03 GMT

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

Re: Section Access on multiple fields in different table

marcus_sommer — Mon, 02 May 2022 17:07:12 GMT

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

Re: Section Access on multiple fields in different table

punitpopli — Wed, 04 May 2022 07:27:05 GMT

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