Combining table data

[harjedalskok]

Hi,

I would merge in the data from "kundfakturor" to the "Order" table.

the key is Ordernr.

Is this possible?

Order:

LOAD    OrderId,  

        OrderNo as Ordernr,

        OrderTypeId,

        ;

SQL

EXEC QV_ORDER_BY_SALESDATE $(vFromDate);

KundFakturor:

Load

FakturaNr,

KontaktNr as Ordernr, //lagt till för att koppla fakturerat till försäljning

//VarReferens as Säljare

if(VarReferens = 'Tom Lindgren', 'Tom Heikka',if(VarReferens = 'Emma Carlsson', 'Emma Hellström',if(VarReferens = 'Jonas Andersson', 'Jonas Grønbech',if(VarReferens = 'Eric Johansson', 'Eric Strandelin',VarReferens)))) as KSäljare

;

SQL SELECT

    FakturaNr, KontaktNr, VarReferens,

FROM "HogiaEconomy_0003".dbo.KundFaktura

where FakturaDatum >='2017-04-01'

;

[marcelviegas]

Order:

LOAD    OrderId, 

        OrderNo as Ordernr,

        OrderTypeId,

        ;

SQL

EXEC QV_ORDER_BY_SALESDATE $(vFromDate);

concatenate    // or   left join

KundFakturor:

Load

FakturaNr,

KontaktNr as Ordernr, //lagt till för att koppla fakturerat till försäljning

//VarReferens as Säljare

if(VarReferens = 'Tom Lindgren', 'Tom Heikka',if(VarReferens = 'Emma Carlsson', 'Emma Hellström',if(VarReferens = 'Jonas Andersson', 'Jonas Grønbech',if(VarReferens = 'Eric Johansson', 'Eric Strandelin',VarReferens)))) as KSäljare

;

SQL SELECT

    FakturaNr, KontaktNr, VarReferens,

FROM "HogiaEconomy_0003".dbo.KundFaktura

where FakturaDatum >='2017-04-01'

[harjedalskok]

Thx for answer, is it possible to concatenate through diffrent source/ DB?

[marcelviegas]

now I understand, I think you can use different qvw's for each db extraction and transform the data into qvd. And in the main file you join everything with the concatenate or join

At the beginning of the file:  directory c:\"example";

table_order:

Order:

LOAD    OrderId,

        OrderNo as Ordernr,

        OrderTypeId,

        ;

SQL

EXEC QV_ORDER_BY_SALESDATE $(vFromDate);

store table_order into table_order.qvd;

table_order:

load*

from table_order.qvd;

concatenate

.......