Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Joining two tables

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.

1 Solution

Accepted Solutions
Not applicable
Author

see attached,

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

Regards

View solution in original post

8 Replies
calvindk
Creator III
Creator III

You need to unqualify your keys.

You do it like this

UNQUALIFY KEYFIELD;

Table:

KEYFIELD,

data

Tabl2:

KEYFIELD,

otherdata

Not applicable
Author

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

Not applicable
Author

Hi,

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

Regards

Not applicable
Author

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

Not applicable
Author

did u modify the file i attached ?

Regards

Not applicable
Author

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

Not applicable
Author

see attached,

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

Regards

Not applicable
Author

Hi,

Thank you so much for you help.

That works great.

Cheers