topic Re: table not found in QlikView

table not found

gauthamchilled — Fri, 21 Aug 2015 08:19:08 GMT

I am getting the table not found error...in the attached qvw

can anyone help?

Re: table not found

pokassov — Fri, 21 Aug 2015 08:20:38 GMT

Table1:

Load * inline

[

A,B

10.20

];

Tab3:

Load * Inline

[A,F

10,90

];

Left join (Tab3)

load *

Resident Table1;

Re: table not found

alexandros17 — Fri, 21 Aug 2015 08:25:38 GMT

I've seen your doc but what do you want to do?

Re: table not found

gauthamchilled — Fri, 21 Aug 2015 08:35:01 GMT

I am trying to left join a resident table with other resident table where I encounter table not found error. attached was a example. but in my original doc I keep getting the same error.

Re: table not found

jagan — Fri, 21 Aug 2015 08:44:19 GMT

Hi Gautham,

You missed INLINE keyword in your script, please try below script

Table1:

Load * inline

[

A,B

10.20

];

Tab3:

Load *

INLINE

[A,F

10,90

];

Left join (Tab3)

load *

Resident Table1;

Re: table not found

alexandros17 — Fri, 21 Aug 2015 08:45:28 GMT

So this could be the solution?

Table1:

Load * inline

[

A,B

10,20

];

Left Join

Tab3:

Load * Inline

[A,F

10,90

];

Re: table not found

Fri, 21 Aug 2015 08:48:07 GMT

Hi. You forget inline in second table

Table1:

Load * inline
[
A,B
10.20
];

Tab3:

Load * inline

Re: table not found

Alvaro_Palacios — Fri, 21 Aug 2015 08:51:25 GMT

Hi Gautham,

Another way of doing it that works for me:

Tab3:

Load * inline

[A,F

10,90

];

Left join (Tab3)

Load * inline

[

A,B

10,20

];

Re: table not found

gauthamchilled — Fri, 21 Aug 2015 08:56:13 GMT

hi,

attached the document where I face the issue by replicating with similar example.

Re: table not found

gauthamchilled — Fri, 21 Aug 2015 09:00:07 GMT

Re: table not found

Fri, 21 Aug 2015 09:04:13 GMT

you mast insert NoConcatenate like this

NoConcatenate
RatesUSD:
Load
Currency,
DATE,
Rates
Resident Tab1;

DROP Table Tab1;

Re: table not found

sasiparupudi1 — Fri, 21 Aug 2015 09:10:49 GMT

Try like this

Data:

Load * inline

[Sales,DATE

5000,10/11/2014

3000,11/11/2014

];

Tab1:

Load * inline

[

Currency,DATE,Rates

INR,10/11/2014,2.0123

MYR,11/11/2014,2.0113

];

NoConcatenate

RatesUSD:

Load

Currency,

DATE,

Rates

Resident Tab1;

DROP Table Tab1;

New:

Load

Sales AS OriginalData,

DATE AS ExchangeRateDate,

'INR' as OriginalCurrency

Resident Data;

Left Join (New)

Load

Currency as OriginalCurrency,

Rates as MYR

Resident RatesUSD;