Using Concatenate in Section Access

[tmumaw]

Hi all,

Just wondering if you can use concatenate in Section Access something like this:

Section Access;

LOAD
"ACCESS",
"USERID",
"SAPROFITCENTER"
FROM [lib://QVD/Section Access/Admins.xlsx]
(ooxml, embedded labels, table is Document_TB03);

Concatenate
LOAD
"ACCESS",
"USERID",
"SAPROFITCENTER"
FROM [lib://QVD/Section Access/SECAccess.QVD]
(qvd);

Section Application;

It appears the first part is working but not the second.

Thanks

[agigliotti · Accepted solution]

Hi @tmumaw ,
I think you could.
Anyway to be sure simple create a table in the section application like below:

Section Access;

TA_SA:
LOAD
"ACCESS",
"USERID",
"SAPROFITCENTER"
FROM [lib://QVD/Section Access/Admins.xlsx]
(ooxml, embedded labels, table is Document_TB03);

Concatenate
LOAD
"ACCESS",
"USERID",
"SAPROFITCENTER"
FROM [lib://QVD/Section Access/SECAccess.QVD]
(qvd);

Section Application;

Table_1:
load * resident TA_SA;

and finally check Table_1 content.

I hope it can help.
Best Regards
Andrea