Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

need urgently right data model for below xl sheet pls make it all fields are inline and send the screen shot because i am using personal addition ?

need urgently  right data model for below xl sheet  pls  make it all fields are inline and send the screen shot because i am using personal addition ?

i  have a given a  logical mapping  and  tables fields mapping  pls   take  all fields as  a inline  and   create  a  good  data model which gives proper relationship   . i am greatful to them who help me here pls  .....

take  each table  like  

MSEG:

LOAD * INLINE

[

MBLNR,

MJAHR,

ZEILE,

BUKRS,

WERKS,

BWART,

BUDAT_MKPF,

];                            


ZZMM_MIGO103DATA :

LOAD * INLINE

[

MBLNR,

MJAHR,

MBLPO,

WERKS,

LIFNR,

MATNR,

VNINV,

VNDAT,

ERFME,

EBELN,

EBELP,

QTY_105,

VNVAL ,

CREATIONDATE,

VNINV,

LGORT

];

LFA1:

LOAD * INLINE

[

LIFNR,

Name 1,

PSTLZ

];

MAKT:

LOAD * INLINE

[

MATNR,

SPRAS,

MAKTX

];

MBEW:

LOAD * INLINE

[

MATNR,

BWKEY,

BWTAR,

BKLAS

];

J_1IEXCDTL:

LOAD * INLINE

[

TRNTYP,

DOCYR,

DOCNO,

ZEILE,

LIFNR,

LGORT,

MATNR,

MENGE,

LGORT,

EXBAS,

EXBED,

RDOC1

];

2 Replies
mikkeltaylor
Creator II
Creator II

What is it you are having trouble with?

i Would have a go at creating the data model first yourself and then posting back what issues you face, rather than ask the community to do the work for you.

don_qlikview
Creator
Creator

Need more details!!!