Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am just starting to understand the load script syntax for bringing in data to Qlik Sense Desktop from SAP.
In this case, I would like to limit the Material Group selections (MATKL) to 30080600, and this part works.
Next, I load from MAKT (Material Description), but I only want load material descriptions for the material group of 30080600 - not the entire data set.
Here is what I have - appreciate any assistance:
[MARA]:
LOAD MATNR as ProdKey,
MSTAE as LifeCycle,
MATKL as MaterialGroup where MATKL = '30080600';
SELECT MATNR,
MATKL,
MSTAE
FROM MARA;
// STORE * FROM [MARA] INTO [LIB://FolderConnection/MARA.qvd];
// DROP TABLE [MARA];
[MAKT]:
LOAD MATNR as ProdKey,
MAKTX as MatlDesc;
SELECT MATNR,
MAKTX
FROM MAKT;
// STORE * FROM [MAKT] INTO [LIB://FolderConnection/MAKT.qvd];
// DROP TABLE [MAKT];
I did some digging and found the left join to work - although the syntax took some time to figure out:
[MARA]:
LOAD MATNR as ProdKey,
MSTAE as LifeCycle,
MATKL as MaterialGroup where MATKL = '30080600';
SELECT MATNR,
MSTAE,
MATKL
FROM MARA;
// STORE * FROM [MARA] INTO [LIB://FolderConnection/MARA.qvd];
// DROP TABLE [MARA];
// // NoConcatenate
[MAKT]:
LOAD MATNR as ProdKey,
// MANDT as MandtKey,
MAKTX as MatlDesc;
SELECT MATNR,
// MANDT,
MAKTX
FROM MAKT;
// STORE * FROM [MAKT] INTO [LIB://FolderConnection/MAKT.qvd];
// DROP TABLE [MAKT];
// join descriptions
Left join (MARA)
Load * Resident MAKT;
Drop table MAKT;
I did some digging and found the left join to work - although the syntax took some time to figure out:
[MARA]:
LOAD MATNR as ProdKey,
MSTAE as LifeCycle,
MATKL as MaterialGroup where MATKL = '30080600';
SELECT MATNR,
MSTAE,
MATKL
FROM MARA;
// STORE * FROM [MARA] INTO [LIB://FolderConnection/MARA.qvd];
// DROP TABLE [MARA];
// // NoConcatenate
[MAKT]:
LOAD MATNR as ProdKey,
// MANDT as MandtKey,
MAKTX as MatlDesc;
SELECT MATNR,
// MANDT,
MAKTX
FROM MAKT;
// STORE * FROM [MAKT] INTO [LIB://FolderConnection/MAKT.qvd];
// DROP TABLE [MAKT];
// join descriptions
Left join (MARA)
Load * Resident MAKT;
Drop table MAKT;