topic Re: Combining table data in QlikView

Combining table data

harjedalskok — Wed, 25 Nov 2020 16:16:04 GMT

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'

;

Re: Combining table data

marcelviegas — Thu, 24 Aug 2017 12:08:44 GMT

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

;

SQL SELECT

FakturaNr, KontaktNr, VarReferens,

FROM "HogiaEconomy_0003".dbo.KundFaktura

where FakturaDatum >='2017-04-01'

Re: Combining table data

harjedalskok — Thu, 24 Aug 2017 14:17:30 GMT

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

Re: Combining table data

marcelviegas — Thu, 24 Aug 2017 14:32:35 GMT

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

.......