Joining two tables

[#1]

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.

[calvindk]

You need to unqualify your keys.

You do it like this

UNQUALIFY KEYFIELD;

Table:

KEYFIELD,

data

Tabl2:

KEYFIELD,

otherdata

[#3]

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

[#4]

Hi,

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

Regards

[#5]

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

[#6]

did u modify the file i attached ?

Regards

[#7]

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

[#8 · Accepted solution]

see attached,

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

Regards

[#9]

Hi,

Thank you so much for you help.

That works great.

Cheers