Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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