Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Creating a Data Model

Creating a Data Model

Hi I am trying to create one table from 3 tables and I was wondering what the script would look like in the data load editor to accomplish this:

The tables and fields are as follows:

Table 1:

"/BIC/B_VGBEL.PO Reference Number",

"/BIC/W_IHREZ.PO Type",

"/BIC/W_LINES.Lines",

"/BIC/W_UNITS.Alter.Units",

"/BIC/W_WERKS.Plant",

"/BIC/W_XLTYP.Storage type",

"CALDAY.Calendar day",


"CALMONTH.Cal. year / month"

 

Table 2:

"/BIC/B_VGBEL.PO Reference Number",

"/BIC/W_ERDAT.Create date",
    "/BIC/W_ERZET.Create time",

"/BIC/W_IHREZ.PO Type",

"/BIC/W_LINES.Lines",

"/BIC/W_PUTSTA.Put-Away Status",

"/BIC/W_UNITS.Alter.Units",

 "/BIC/W_WERKS.Plant",

"CALDAY.Calendar day",
    "CALMONTH.Cal. year / month"

 

Table 3:

"/BIC/M_BWART.Movement Type",

"/BIC/M_LGORT.Storage Location",

"/BIC/ZPLANT.Plant",

"CALMONTH.Cal. year / month",

 

Any help would be greatly appreciated.  Really all I want is one table merged together from all 3 tables where I can write expressions against. 

 

Thanks in advance!

 

 

3 Replies
Highlighted

Hi 

You can concatenate the Table1 & Table 2.. But table 3, doesn't have common fields except (CALMONTH.Cal. year / month). So you can keep table 3 separately. 

Highlighted
Contributor II
Contributor II

Hi Mayilvahanan,

 

Thanks for the suggestion.  I actually need to bring in the field "/BIC/W_LINES.Lines" also from Table 2 as I need to write an expression against Table 3 that would be calculating the number of lines with other criteria in Table 3.  Is there any way I can put all 3 of these tables together into one table?

Would you be able to give me a breakdown of what the script would look like in the data load editor?

Thanks and I really appreciate your help

Osman

Highlighted
Contributor III
Contributor III

Table 1 and Table 2 should be concatenated to avoid synthetic key and Table 3 can be joined in case if you want to do any calculation.

Table 1:

......

Concatenate

Table 2:

......

Join

Table 3:

.......