Creating a Data Model

okamal99 — Thu, 23 May 2019 16:15:12 GMT

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

Re: Creating a Data Model

JordyWegman — Tue, 04 Jun 2019 11:57:16 GMT

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

Re: Creating a Data Model

PrashantSangle — Tue, 04 Jun 2019 12:09:24 GMT

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,

topic Re: Creating a Data Model in Connectivity & Data Prep

Creating a Data Model

Re: Creating a Data Model

Re: Creating a Data Model