topic Re: How to join two single tables in QlikView

How to join two single tables

Wed, 23 Jan 2013 15:41:21 GMT

Hello

I have just two single tables i like to join. How is the syntax?

SQL SELECT

actno, nm, supno

FROM F1100.dbo.Actor;

SQL SELECT

R2, R10, VoNo, EntNo, Sup, AcNo, VoDt, AcPr, Qty, AcAm, Txt, Txt2

FROM F1100.dbo.AcTr;

I like to join supno and sup....

Please help

Re: How to join two single tables

Wed, 23 Jan 2013 16:01:17 GMT

You will need to rename the two fields to have the same name. Then QV will join them automatically.

Re: How to join two single tables

Wed, 23 Jan 2013 17:47:31 GMT

Hello Heather

I can not rename this fields in SQL database. This is in use from the main acounting system. Is it some way to rename in QV?

Re: How to join two single tables

Wed, 23 Jan 2013 17:49:45 GMT

Sorry, I should have been more clear. Just give them an alias in the query, not rename in the database.

Re: How to join two single tables

Gysbert_Wassenaar — Wed, 23 Jan 2013 18:01:16 GMT

Give the field Sup the alias supno. That way Qlikview can associate the two tables:

Table1:

SQL SELECT

actno, nm, supno

FROM F1100.dbo.Actor;

Table2:

SQL SELECT

R2, R10, VoNo, EntNo, Sup as supno,

AcNo, VoDt, AcPr, Qty, AcAm, Txt, Txt2

FROM F1100.dbo.AcTr;

Re: How to join two single tables

Wed, 23 Jan 2013 20:45:06 GMT

Thanks !! I give it a try tomorrow

Re: How to join two single tables

Thu, 24 Jan 2013 11:32:50 GMT

I have tested, and i works perfekt!!

Thanks to all