Using Concatenate in Section Access

tmumaw — Sat, 16 Nov 2024 17:36:00 GMT

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

Re: Using Concatenate in Section Access

agigliotti — Tue, 19 Jan 2021 14:15:49 GMT

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