Merge two files without comparing

magesh23586 · Posted: Wed Jul 03, 2013 1:39 pm

Hi,

I need to merge two columns from couple of files without comparing, I know files are in same sequence , I need to overlay some values from file2.

I tried with joinkey, but it asking me for joinkey and its comparing and changing the sequence of the file.

Requirement is to concatenate/merge (F1:1,93,F2:94,25,F1:119,13)
F1 is file1
F2 is File2

need not compare, need not sort, just overlay these F2 records

Please help me on this.

Pandora-Box · Posted: Wed Jul 03, 2013 1:46 pm

Why do you dont want to use Joinkeys?

Is that the requirement to be done without Joinkeys?

magesh23586 · Posted: Wed Jul 03, 2013 1:51 pm

Joinkeys is sorting the file, hence sequence of the file is affected , I don't want to compare actually and I don't know the way to directly concatenate two columns. Hence I tried joinkey, Is there any way to just concatenate two columns from two different files, Sequence should be same as the input file.

Regards,
Magesh

Pandora-Box · Posted: Wed Jul 03, 2013 1:59 pm

What you could do is

use JNFCNTLn

To Add sequence number to both the files and join based on the sequence

Or

Did you try SORTED??

magesh23586 · Posted: Wed Jul 03, 2013 2:04 pm

How do I do this, It would be great if you could share the code.

magesh23586 · Posted: Wed Jul 03, 2013 2:06 pm

JOINKEYS FILE=F1,FIELDS=(67,17,A),SORTED is failed because joinkey I mentioned is out of sequence

expat · Posted: Wed Jul 03, 2013 2:25 pm

Not sure if it will override the sequence checking, but you could try

SORTED,NOSEQCK instead of SORTED

magesh23586 · Posted: Wed Jul 03, 2013 2:34 pm

Still the sequence of the output file is changed

I think it is because of =(67,17,A) is there any way to avoid this 'A'

Pandora-Box · Posted: Wed Jul 03, 2013 2:49 pm

Check this example

magesh23586 · Posted: Wed Jul 03, 2013 2:57 pm

You example will work, if we have an empty column, Both of my files have complete data, no empty column, I cant give the length beyond the file RECL.

Regards,
Magesh

expat · Posted: Wed Jul 03, 2013 3:01 pm

I suggest that you try the code before saying it will not work for you.

Why do you think that you need a "empty column" ?

Pandora-Box · Posted: Wed Jul 03, 2013 3:14 pm

magesh23586 · Posted: Wed Jul 03, 2013 3:15 pm

Got the solution

From File1 I don't requires 94,25 hence I can overlay the sequence number for file1 in 94th position, llly for file2 1 to 93 I can use for overlay.

Created the below code, It worked fine, Thanks Expat and Pandora-Box

dick scherrer · Posted: Wed Jul 03, 2013 9:01 pm

Hello,

You still do not understand . . .

You Need to try the posted code. Not just throw something else together. Your "solution" will not work in every case. The sample posted will.

The example builds a sequence number beyond the end of the input record and discards this in the reformat.

If you are unwilling to try the code provided, why ask in the first place?

If you intend to use the "works for this format only" code you showed, you have wasted everyone's time . . .

Bill Woodger · Posted: Thu Jul 04, 2013 5:29 am

Well done for spotting that you can re-use part of the F1 record.

You can further cut down your F1 and your F2 just to the minimum (only the data you need). Might not make much difference this time, but it is a good habit to get in to, as if you needed to have the JOINKEYS do a SORT (for a different requirement), the less data the better.