topic Re: Load, Resident, Left Join (ERROR) in QlikView

Load, Resident, Left Join (ERROR)

Thu, 24 Jan 2013 11:22:42 GMT

Hi all,

I have a table called Bookings in one tab in the run script and Patients in another tab in the run script. I need to join both the tables.

Bookings:

Load

ID,

Name,

Phone

;

From

Sql *......

The code I had written was

Patients:

Load

No as ID,

Location

;

Sql*......

LEFT JOIN (Patients)

Load

ID,

Name,

Phone

Resident Bookings;

I get a syntax error. Not sure if the left join code is the right one.

Re: Load, Resident, Left Join (ERROR)

Gysbert_Wassenaar — Thu, 24 Jan 2013 11:36:29 GMT

The from keyword should probably be removed from your first load statement

Load

ID,

Name,

Phone

;

From

Sql *......

That last bit doesn't look right. You either use a preceding load without a from in the load statement (but it the sql statement does need it)

Load

a,b,c;

sql select * from mytable;

Or just

sql select a,b,c from mytable;

Or load from a non-sql source

Load

a,b,c

from myqvd (qvd);

Re: Load, Resident, Left Join (ERROR)

er_mohit — Thu, 24 Jan 2013 11:52:41 GMT

Bookings:

Load

ID,

Name,

Phone

;

From

Sql *......

The code I had written was

concatenate(Booking)

Patients:

Load

No as ID,

Location

;

Sql*......

where not exit(ID); // before ';'in your sql satatement write this where condition.

Re: Load, Resident, Left Join (ERROR)

Thu, 24 Jan 2013 12:02:53 GMT

Changed it. Both the tables load perfectly. Only when I add the Left join, it gives a syntax error.

Re: Load, Resident, Left Join (ERROR)

er_mohit — Thu, 24 Jan 2013 12:04:14 GMT

you should have mark it as helpful or correct answer.

so it might be helpful for other developer

Re: Load, Resident, Left Join (ERROR)

Thu, 24 Jan 2013 12:10:56 GMT

Thanks Mohit. I always mark if its a correct answer.

Re: Load, Resident, Left Join (ERROR)

er_mohit — Thu, 24 Jan 2013 12:13:17 GMT

tell me what problem which you are facing now

Re: Load, Resident, Left Join (ERROR)

Thu, 24 Jan 2013 12:15:49 GMT

Tables load perfectly. When I add the Left join, and reload it gives me a error.

Re: Load, Resident, Left Join (ERROR)

er_mohit — Thu, 24 Jan 2013 12:24:35 GMT

Bookings:

Load

ID,

Name,

Phone

;

From

Sql *......

join(Bookings)

Patients:

Load

No as ID,

Location

;

Sql*......

hope it helps

if it gives error then write in last load of your statement before ;

where not exit(ID);

Re: Load, Resident, Left Join (ERROR)

jagan — Thu, 24 Jan 2013 12:54:57 GMT

Hi,

In Join you have given the invalid table name(Booking instead of Bookings).

Bookings:

Load

ID,

Name,

Phone

;

From

Sql *......

join(Bookings)

Load

No as ID,

Location

;

Sql*......

Hope this helps you.

Regards,

Jagan.