Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

okamal99
New Contributor II

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.  I've tried joins and qualifying and unqualifying fields and it doesn't seem to be working.

 

Thanks in advance!

 

Osman

 

 

2 Replies
Partner
Partner

Re: Creating a Data Model

Hi,

I can't see the outcome, but you can do this:

Table1:
Load
  *
From [YourSourceTable1] (qvd);

Left Join(Table1)
Load
  *
From [YourSourceTable2] (qvd);

Left Join(Table1)
Load
  *
From [YourSourceTable3] (qvd);

Jordy

Climber

Work smarter, not harder

Re: Creating a Data Model

what are the common fields on all of them through which you want to combine them in one table??
To combine all 3 tables in one table you can use
1: concatenate
2: join

regards,
Great dreamer's dreams never fulfilled, they are always transcended.