About sbhaskarit

sbhaskarit · ‎05-24-2018

I have used the attached template and additionally used putfile processor at last to get all the files into a folder. But I am facing an issue while generating the file. It is trying to generate the files with the same file name for which it is throwing error like file name is existing, so getting the last file based on the line number count split. Is there a way to get the files in a folder with different-2 names? Flow is as below: GetFile-->Queryrecord-->putFile

sbhaskarit · ‎05-24-2018

Hey Umair, Thanks to pointing out. I was trying the same. I was trying with the following flow: GetFile--->SplitText--->PutFile Using above case, I am getting only first file using the line number. How to get the other remaining files. If you have any template to do so then need your help. Please share the template xml file.

sbhaskarit · ‎05-22-2018

Appreciate your prompt response. Could you please share the template xml to proceed on this. I have done lot of exercise on this with no luck.

sbhaskarit · ‎05-22-2018

I Have a file (let's say 1.csv) having below records with 4 lines: id,name,age,location 1,Shailesh,35,Bangalore 2,Ajay,25,Goa 3,Sanjay,30,Chennai 4,Raman,32,Hyderabad I want to split the file 1.txt into 2 files (lets say 2.csv and 3.csv) except header using line number and it should be as below: ============== 2.csv-----> 1,Shailesh,35,Bangalore 2,Ajay,25,Goa ================== 3.csv----> 3,Sanjay,30,Chennai 4,Raman,32,Hyderabad ====================== Didn't get proper solution. Need some suggestion and help to proceed on this.

Online	Offline
Last Visited	‎05-27-2018 10:59 AM

Member Since	‎05-22-2018 11:26 AM
Last Visited	‎05-27-2018 10:59 AM
Posts	4

Cloudera Community

Re: Split a File into multiple files using line nu...

Re: Split a File into multiple files using line nu...

Re: Split a File into multiple files using line nu...

Split a File into multiple files using line number