Hi Experts,
I am having an input data as follows
col1 1,2,3,4,5,6,7,8....
col2 qa,ee,rrrr,fff,wds,r,fff,.....
while i tried to read this data with sequential stage its throwing error as "consume more than 10000 bytes looking for record delimiter, aborting"
Could you please suggest me which stage I have to use with some examples.
Thanks in advance
How to read the complex text data
Moderators: chulett, rschirm, roy
How to read the complex text data
Ramesh Kumar.M
Is that exactly the what the file content looks like or is it like this:
1,"qa"
2,"ee"
etc.
Go into the format tab on the sequential file stage and set quote characters and delimiters and record delimiters to make them match the layout of the file.
1,"qa"
2,"ee"
etc.
Go into the format tab on the sequential file stage and set quote characters and delimiters and record delimiters to make them match the layout of the file.
Choose a job you love, and you will never have to work a day in your life. - Confucius