error to to import txt to CSV file

Majid1357

 when I run to read CSV operator, it keep show me error that " An attribute 0 was specified for column 1 but this column does not exist in input data " how I can solve this issue ?

jacobcybulski

What I suggest is to NOT to follow that lengthy workshop the way it is structured. Try getting a single file in and see if it worked. Then try getting only files, of which names match a certain patterns and see if it works. Finally do it the way it is done in the workshop but put a log inside the directory scanning loop to see what was the last file which was found in that director and which lead to failure. Check this file out as quite likely it is not what you think it is. Perhaps, you have left the ZIP file in that directory or you have some other file, perhaps a system file? Perhaps yo have a file in the wrong encoding (Windows rather than UTF or vice versa). So do this in little steps.

Jacob

jacobcybulski

I am not sure why you have an input into "Read CSV", do you really mean it? If you are reading the CSV file from disk then you do not need that "fil" input. Otherwise, it is assumed that you have a file "in your hand" and you are passing it into the "Read CSV" operator. If this is NOT so, your "Read CSV" will be confused when you configure it with a wizard on an existing file on disk but then you pass in some other file (or junk) which may not conform to the format remembered in your meta information.

Jacob

Majid1357

Yes will follow your way and let you know

Thanks

Majid1357

Yes let me see How I can fix that, Thank you for your time and replay will let you know if its solved