merge 4 flat files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
merge 4 flat files
hi,
u have 4 flat files ,in thes 4 files i have 14 column names same,how could i merge them into single flat file.they are no common values in them.
Thanks
sunitha
u have 4 flat files ,in thes 4 files i have 14 column names same,how could i merge them into single flat file.they are no common values in them.
Thanks
sunitha
Re: merge 4 flat files
u can merge them using FUNNEL Stage.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
So can anyone else.
U is the name of one of our posters.
The second person personal pronoun in English is spelled "you", not "u".
Please strive for a professional standard of written English on DSXchange. It assists those whose first language is not English, if they don't have to decode your SMS-style abbreviations.
U is the name of one of our posters.
The second person personal pronoun in English is spelled "you", not "u".
Please strive for a professional standard of written English on DSXchange. It assists those whose first language is not English, if they don't have to decode your SMS-style abbreviations.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 41
- Joined: Sat Jun 06, 2009 11:13 pm
- Location: Kolkata
Use Funnel Stage
Funnel stage will solve the problem. If you want sorted output, then you can try with the sort funnel option. Or else sequence funnel option is the best to my opinion as per the performance is concerned.
Nayan
-
- Premium Member
- Posts: 48
- Joined: Tue Nov 25, 2008 11:10 pm
- Location: Des Moines,IA
Re: Use Funnel Stage
I don't think funnel stage is available in Server edition. As stated by sainath, "Link collector"
"It's easier to go down a hill than up it but the view is much better at the top"
-Bennet,Arnold
-Bennet,Arnold
As noted, there is no Funnel stage in Server jobs. Please pay attention to the job type when posting.
And as normal, Sunitha needs to do a better job of asking questions to get proper answers. What do you mean by "merge" here, especially after making the comment that "they have no common values in them"? While they may not have common "values" is the metadata the same in all files? If so can you not simply "cat" the four of them together? If not, you need to explain why not.
And as normal, Sunitha needs to do a better job of asking questions to get proper answers. What do you mean by "merge" here, especially after making the comment that "they have no common values in them"? While they may not have common "values" is the metadata the same in all files? If so can you not simply "cat" the four of them together? If not, you need to explain why not.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
Hi,
moving all the 4 flat files into one flat file,so finally that file is used as input for another job.
i have about 14 columns common in each of the 4 flat files,so i am manually entering the columns and assigning 'null' to the columns not required.
I THINKK THEY IS OTHER OPTION TO DO IN SERVER JOBS.
Thanks
sunitha
moving all the 4 flat files into one flat file,so finally that file is used as input for another job.
i have about 14 columns common in each of the 4 flat files,so i am manually entering the columns and assigning 'null' to the columns not required.
I THINKK THEY IS OTHER OPTION TO DO IN SERVER JOBS.
Thanks
sunitha
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Answer this question. Consider row #1 in each of the four files. Will these result in one row or in four rows in the target file? (We really do need to understand what you mean by "merge".)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.