Join issue

[#1]

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]

[anbu1984]

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

[Anonymous · Accepted solution]

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

Ex:

[No.of Messages]:

NoConcatenate

LOAD Subject

[PrashantSangle]

Hi,

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

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

Regards

[Anonymous]

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

[#6]

Thanks for your explanation.