Batch : concatenation (File1 Column) x | (File2 colum y)
Batch : concatenation (File1 Column) x | (File2 colum y)
Hi,
I try to make a concatenation with a job in batch between 2 files with a single line in each one and using diferent part of each files. This files don't have the same lg (80 for E1, 133 for E2).
I need to take the informations on file 1 in position 4 (on 5 caracters) + informations on file 2 in position 13 (on 120 caracters).
I don't know if I can use a Sort, Fileaid, UT4* on an other utilities ...
Thanks in advance for your answer.
I try to make a concatenation with a job in batch between 2 files with a single line in each one and using diferent part of each files. This files don't have the same lg (80 for E1, 133 for E2).
I need to take the informations on file 1 in position 4 (on 5 caracters) + informations on file 2 in position 13 (on 120 caracters).
I don't know if I can use a Sort, Fileaid, UT4* on an other utilities ...
Thanks in advance for your answer.
- Anuj Dhawan
- Founder
- Posts: 2806
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Batch : concatenation (File1 Column) x | (File2 colum y)
SORT would be preferred method, for me.
What are the positions of the "keys", in both files, to make the match upon? Can you please show some sample records?
PS: Do you know which SORT product is in use at your shop?
What are the positions of the "keys", in both files, to make the match upon? Can you please show some sample records?
PS: Do you know which SORT product is in use at your shop?
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Re: Batch : concatenation (File1 Column) x | (File2 colum y)
Please note that they are not files but datasets. There is a difference.
Regards
Nic
Nic
-
- Website Team
- Posts: 70
- Joined: Wed Jul 31, 2013 10:19 pm
Re: Batch : concatenation (File1 Column) x | (File2 colum y)
SORT Join would help you. Check for JOINKEYS in DFSORT manual.
But yes as Anuj said,before we would like to know the sample records and DFSORT product
Thanks and regards,
Chandan
But yes as Anuj said,before we would like to know the sample records and DFSORT product
Thanks and regards,
Chandan
Re: Batch : concatenation (File1 Column) x | (File2 colum y)
First, thanks for your quick answers.
In my company, we use SyncSort Product.
Datasets 1 is :
;25/03/2016;13:32:14;25/03/2016;13:33:43;25/03/2016;
Datasets 2 is :
V V0012220160318
In Final I want :
xxxxxx;00122;25/03/2016;13:32:14;25/03/2016;13:33:43;25/03/2016;
(xxxxx it's just some text)
In my company, we use SyncSort Product.
Datasets 1 is :
;25/03/2016;13:32:14;25/03/2016;13:33:43;25/03/2016;
Datasets 2 is :
V V0012220160318
In Final I want :
xxxxxx;00122;25/03/2016;13:32:14;25/03/2016;13:33:43;25/03/2016;
(xxxxx it's just some text)
-
- Global Moderator
- Posts: 828
- Joined: Wed Sep 11, 2013 3:57 pm
Re: Batch : concatenation (File1 Column) x | (File2 colum y)
repost Your data without colours and using only the CODE tags
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
Re: Batch : concatenation (File1 Column) x | (File2 colum y)
Datasets 1 :
Datasets 2 :
Final Dataset :
Code: Select all
;25/03/2016;13:32:14;25/03/2016;13:33:43;25/03/2016;13:34:45;
Datasets 2 :
Code: Select all
V V0012220160318
Code: Select all
xxxxxx;00122;25/03/2016;13:32:14;25/03/2016;13:33:43;25/03/2016;13:34:45;
Re: Batch : concatenation (File1 Column) x | (File2 colum y)
Hi,
no idea ?
I search aout JOINKEYS, but I don't find a solution because I don't have a key between my two files...
no idea ?
I search aout JOINKEYS, but I don't find a solution because I don't have a key between my two files...
-
- Website Team
- Posts: 70
- Joined: Wed Jul 31, 2013 10:19 pm
Re: Batch : concatenation (File1 Column) x | (File2 colum y)
Hi,
How you are going to decide which record of file 2 you are going to consider for populating it in File 1?
Thanks and regards,
Chandan
How you are going to decide which record of file 2 you are going to consider for populating it in File 1?
Thanks and regards,
Chandan
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute