table not found

[gauthamchilled]

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

can anyone help?

[pokassov]

Table1:

Load * inline

[

A,B

10.20

];

Tab3:

Load * Inline

[A,F

10,90

];

Left join (Tab3)

load *

Resident Table1;

[alexandros17]

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

[gauthamchilled]

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.

[jagan]

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;

[alexandros17]

So this could be the solution?

Table1:

Load * inline

[

A,B

10,20

];

Left Join

Tab3:

Load * Inline

[A,F

10,90

];

[#7]

Hi. You forget  inline in second table

Table1:

Load * inline
[
A,B
10.20
];

Tab3:

Load * inline

[Alvaro_Palacios]

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

];

[gauthamchilled]

hi,

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

[gauthamchilled]