Creating a Data Model

[okamal99]

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

[JordyWegman]

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

[PrashantSangle]

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,