topic Re: Left join question in QlikView

Left join question

Fri, 31 Jan 2014 21:34:30 GMT

HI guys,

I am doing the following join which works perfectly..

left join (SalesLines)

Load TxnID, TxnDate Resident Sales;

It joins on TxnID.

Now i need to take all fields of Sales in Sales Lines so I wish to do something like this

left join (SalesLines)

Load TxnID, * Resident Sales;

and it does not work.

Any suggestion?

Re: Left join question

iktrayanov — Fri, 31 Jan 2014 21:38:21 GMT

Try

left join (SalesLines)

Load * Resident Sales;

Re: Left join question

Fri, 31 Jan 2014 21:41:40 GMT

I tried that but it did not work...it did not bring any data to SalesLines.

Re: Left join question

Fri, 31 Jan 2014 21:44:00 GMT

Hi,

Have you checked there's not a single field name apart from TxnID and TxnDate that is common to both tables? That's usually the trap with this kind of "massive join".

You can also try:

join (SalesLines)

Load * Resident Sales

where exists (TxnID)

;

The result may show what causes the issue.

Hope it helps.

Re: Left join question

Sat, 01 Feb 2014 04:20:43 GMT

It gives error saying that "exists" field does not exist.

Re: Left join question

Sat, 01 Feb 2014 08:07:03 GMT

Sorry, I had forgotten the parenthesis. Edited in previous post.

Where exists (TxnID)

Have you checked there's no other field named the same way between the 2 tables?

Re: Left join question

MK_QSL — Sat, 01 Feb 2014 09:04:49 GMT

Let us know the exact fields of both tables.... Hope you are not applying Where Exist in SQL Select load.

Re: Left join question

Sat, 01 Feb 2014 16:46:40 GMT

it does not give any error but it did not any data from sales to salesline either.

Re: Left join question

Sat, 01 Feb 2014 16:47:16 GMT

I am doing this

left join (SalesLines)

Load * Resident Sales

where exists (TxnID);

Re: Left join question

Sat, 01 Feb 2014 16:47:34 GMT

I am doing this.

left join (SalesLines)

Load * Resident Sales

where exists (TxnID);

Re: Left join question

Thu, 22 May 2014 03:57:03 GMT

Hi ,

did you able to resolve this issue ?

i have same issue you have mentioned above.

can you please help ?

Re: Left join question

Anonymous — Thu, 22 May 2014 04:07:42 GMT

Hello Ramya,

Could please create sample QVW with sample data using inline load and share same, so we can help you out.

Thanks & Regards,

Kiran Kokade