JOIN tables infinite loop

Fri, 27 Sep 2013 12:43:59 GMT

Hello

Is it possible with Qlikview to join two table and take all field from table 1 and some fields from table 2

It sound simple, very easy to do in SQL but when I try in Qlikview it always fall into an infinite loop and I have to restart Qlikview

Im new to Qlikview but there are a lot of think much more easier to do in SQL rather than in Qlikview

Here is my syntax

join(tmpqa)

promotest as promox

resident allitems;

So I'm expecting to add the field promox existing in the table allitems into the table tmpqa

Tho only common field into the two table is a field 'itemid' (numeric)

Is there something wrong in my syntax ?

Thank for your help

Re: JOIN tables infinite loop

Fri, 27 Sep 2013 13:33:33 GMT

Hello

I don't know why the join is not working but a map do the job

It sounds a bit tricky but it works

- first I create a map extracting ItemID and promotest from my table allitems

- thhen I apply the map on my tmpqa table