topic Re: Join issue in QlikView

Join issue

Fri, 27 Feb 2015 03:31:38 GMT

Hi,

I am using following code to to create a [No of Message] table. Issue is I am able to see this table at the end (neither in qvw /Table viewer). Could some one tell me what is happening here.

Table viewer which does not have [No.of Messages]

Re: Join issue

anbu1984 — Fri, 27 Feb 2015 03:38:21 GMT

Is this complete script? What fields you have in Inbox and Sentbox tables?

Re: Join issue

Anonymous — Fri, 27 Feb 2015 03:44:57 GMT

Try to add NoConcatenate in front of the first 3 LOAD statements.

Ex:

[No.of Messages]:

NoConcatenate

LOAD Subject

Re: Join issue

PrashantSangle — Fri, 27 Feb 2015 04:45:48 GMT

Hi,

Use NoConcatenate before table " [No.of Messages] "

If this dont work for you then post your complete script.

Regards

Re: Join issue

Anonymous — Fri, 27 Feb 2015 04:52:42 GMT

Hi,

Since [No.of Messages] table has the same field names it is getting auto concatenated to the previous table. Use Noconcatenate before loading this table.

Regards,

Greeshma

Re: Join issue

Fri, 27 Feb 2015 05:00:16 GMT

Thanks for your explanation.