Joining tables

[#1]

I Have:

Expenses_CarKm:

  load

  YearMonth,

  YearMonth & ProfitKmCarNumber As YearMonthCar,

  (ProfitKmEnd - ProfitKmStart) As ProfitKmTotal,

  ProfitKmDrive As ProfitKmDrive,

  (ProfitKmEnd - ProfitKmStart) - ProfitKmDrive As ProfitKmEmpty;

from excel file

And I Have:

TESTING:

LOAD YearMonth,

     [מספר רכב] As ProfitMainCarNumber,

     [סה"כ עלות] As ProfitMainTotal

FROM

(ooxml, embedded labels, table is [תחזוקה וחלפים]);

how do i join Expenses_CarKm and Testing??

[Gysbert_Wassenaar]

Using the JOIN keyword:

Expenses_CarKm:

  load

  YearMonth,

  YearMonth & ProfitKmCarNumber As YearMonthCar,

  (ProfitKmEnd - ProfitKmStart) As ProfitKmTotal,

  ProfitKmDrive As ProfitKmDrive,

  (ProfitKmEnd - ProfitKmStart) - ProfitKmDrive As ProfitKmEmpty;

from ...excel_file...;

JOIN (Expenses_CarKm)

LOAD YearMonth,

     [מספר רכב] As ProfitMainCarNumber,

     [סה"כ עלות] As ProfitMainTotal

FROM

(ooxml, embedded labels, table is [תחזוקה וחלפים]);

[#3]

I alredy loaded the first excel table in different place and i called it Expenses_CarKm

and i don't want to load it again.

i just want to join

LOAD YearMonth,

     [מספר רכב] As ProfitMainCarNumber,

     [סה"כ עלות] As ProfitMainTotal

FROM

(ooxml, embedded labels, table is [תחזוקה וחלפים]);

with Expenses_CarKm fileds.

[joshabbott]

Join (Expenses_CarKm)

LOAD YearMonth,

     [מספר רכב] As ProfitMainCarNumber,

     [סה"כ עלות] As ProfitMainTotal

FROM

(ooxml, embedded labels, table is [תחזוקה וחלפים]);

[mohamed_ahid]

Hi

try this :

TESTING:

LOAD YearMonth,

     [מספר רכב] As ProfitMainCarNumber,

     [סה"כ עלות] As ProfitMainTotal

FROM

(ooxml, embedded labels, table is [תחזוקה וחלפים]);

join(TESTING)

  load

  YearMonth,

  YearMonthCar,

  ProfitKmTotal,

  ProfitKmDrive,

  ProfitKmEmpty;

resdient  Expenses_CarKm;

Hope it helps

[#6]

Hi,

It"s not a problem.. the both tables should exists in the script... then use join  keyword for joining your table like below

Join (Expenses_CarKm)

LOAD YearMonth,

     [מספר רכב] As ProfitMainCarNumber,

     [סה"כ עלות] As ProfitMainTotal

FROM

(ooxml, embedded labels, table is [תחזוקה וחלפים]);