topic Joining two tables in QlikView

Joining two tables

Thu, 09 May 2013 15:58:37 GMT

Hi,

I'm having problems trying to join two tables together. I've tried to make sure all columns the same, but I still seem to miss some data:

I run some scripts which enp giving me a Manual table and a Source table,

but when I try and merge the two I dont get the MonthYear or the MonthActual from the Source.

Plesase see the attached example.

THank you in advance.

Re: Joining two tables

calvindk — Thu, 09 May 2013 16:06:36 GMT

You need to unqualify your keys.

You do it like this

UNQUALIFY KEYFIELD;

Table:

KEYFIELD,

data

Tabl2:

KEYFIELD,

otherdata

Re: Joining two tables

Fri, 10 May 2013 10:34:28 GMT

Hi,

I've tried that and still cant get it to work.

If I do the sugesstion above I get two tables joined side by side.

Can you possibly change my example to work so I can see what you mean.

Cheers

Re: Joining two tables

Fri, 10 May 2013 11:19:23 GMT

Hi,

See attached & check if it works for u and let me know

Regards

Re: Joining two tables

Fri, 10 May 2013 11:36:23 GMT

Hi,

THanks for this, however its doesnt seem to have concatenated the Source Table, just the Manual table.

I've attached the document, updated from your script.

Thank you for your help, its much appreciated.

Cheers

Re: Joining two tables

Fri, 10 May 2013 11:39:33 GMT

did u modify the file i attached ?

Regards

Re: Joining two tables

Fri, 10 May 2013 11:55:15 GMT

It errored saying it couldn't find MonthActual, because in the other table it said MthActual

Thats the only thing i changed

I've aslo attached my source file so that you should be able to run it your self.

Cheers

Re: Joining two tables

Fri, 10 May 2013 12:11:06 GMT

see attached,

you just needed to rename the MonthActual in the Source Table also

Regards

Re: Joining two tables

Fri, 10 May 2013 14:31:34 GMT

Hi,

Thank you so much for you help.

That works great.

Cheers