Page 1 of 1

Overlay one file using the field from input(another) file

PostPosted: Thu May 11, 2017 12:31 am
by sethukutty
I need help on overlaying the OUT file using IN file. IN file has the actual date but few months are missing. I want to fill the right date from IN file into OUT file.

IN File:

20170223
20170324
20170425
20170524
20170623


OUT File has already the date format as follows:

20170101
20170201
20170301
20170401
20170501
20170601
20170701
20170801
20170901
20171001
20171101
20171201


New OUT File should be as follows:

20170101
20170223
20170324
20170425
20170524
20170623
20170701
20170801
20170901
20171001
20171101
20171201


Thanks
Ram

CODE' d

Re: Overlay one file using the field from input(another) fil

PostPosted: Thu May 11, 2017 12:41 am
by NicC
From that description and with the data presented it looks like a simple MERGE operation.

Re: Overlay one file using the field from input(another) fil

PostPosted: Thu May 11, 2017 12:44 am
by sethukutty
The dates are in different column.

Re: Overlay one file using the field from input(another) fil

PostPosted: Thu May 11, 2017 1:07 am
by sethukutty
Dates starts from col 17 in IN file
Dates starts from col 4 in OUT file

Re: Overlay one file using the field from input(another) fil

PostPosted: Thu May 11, 2017 2:48 am
by sethukutty
Sorry. Let me give more information:

IN File has the following data (Dates starts from col 17 in IN file):

XXXXXXXXXXXXXXXX20170223
XXXXXXXXXXXXXXXX20170324
XXXXXXXXXXXXXXXX20170425
XXXXXXXXXXXXXXXX20170524
XXXXXXXXXXXXXXXX20170623
 

OUT File has already the following data (Dates starts from col 4 in OUT file):

XXX20170101
XXX20170201
XXX20170301
XXX20170401
XXX20170501
XXX20170601
XXX20170701
XXX20170801
XXX20170901
XXX20171001
XXX20171101
XXX20171201


I want the OUT file to be

XXX20170101
XXX20170223
XXX20170324
XXX20170425
XXX20170524
XXX20170623
XXX20170701
XXX20170801
XXX20170901
XXX20171001
XXX20171101
XXX20171201


CODED' d AGAIN

Re: Overlay one file using the field from input(another) fil

PostPosted: Thu May 11, 2017 2:54 pm
by NicC
And you are not using the code tags because...?
And they are data sets not "files".

Re: Overlay one file using the field from input(another) fil

PostPosted: Thu May 11, 2017 7:07 pm
by sethukutty
I have used Join keys and made it work. Thanks.