topic Re: Joining tables in QlikView

Joining tables

Fri, 27 Jun 2014 11:48:49 GMT

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??

Re: Joining tables

Gysbert_Wassenaar — Fri, 27 Jun 2014 11:51:55 GMT

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 [תחזוקה וחלפים]);

Re: Joining tables

Fri, 27 Jun 2014 11:55:50 GMT

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.

Re: Joining tables

joshabbott — Fri, 27 Jun 2014 12:57:11 GMT

Join (Expenses_CarKm)

LOAD YearMonth,

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

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

FROM

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

Re: Joining tables

mohamed_ahid — Fri, 27 Jun 2014 13:11:36 GMT

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

Re: Joining tables

Fri, 27 Jun 2014 13:13:48 GMT

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 [תחזוקה וחלפים]);