Dear community,
I need to read a txt file who have empty column names like that :
How can I manage my reader for having all columns ?
Thanks for your help.
Question
Read file with empty column name
+66
You can use a CSV reader and set the Field Names Line to 0, the Data Start Line to 1. Then all columns are named col0, col1, col2, etc. Then you can remove the header with a Tester (col1 = number) and use an AttributeRenamer to rename col0 to number etc.
+66Hi @nielsgerrits
If I do that, I've any data and I can't load my dataset.
Can you share a sample of your input? When I recreate a CSV of your screenshot I can configure the reader this way, so I wonder how your sample looks like.
+6- Supporter
Can you share a sample of your input? When I recreate a CSV of your screenshot I can configure the reader this way, so I wonder how your sample looks like.
Yes of course
+66Can you share a sample of your input? When I recreate a CSV of your screenshot I can configure the reader this way, so I wonder how your sample looks like.
This is how it works for me.
Creator --> FeatureReader.
FeatureReader CSV Parameters:
2021 workspace attached
+6- Supporter
Can you share a sample of your input? When I recreate a CSV of your screenshot I can configure the reader this way, so I wonder how your sample looks like.
I'm jealous 😂
For me it doesn't works 
+51- Evangelist
Can you share a sample of your input? When I recreate a CSV of your screenshot I can configure the reader this way, so I wonder how your sample looks like.
Can you check what is set in the Advance settings?
+66Can you share a sample of your input? When I recreate a CSV of your screenshot I can configure the reader this way, so I wonder how your sample looks like.
Are you using a dynamic input instead of a hard coded? Then you wont see values in the preview but the functionality works.
Also, when using a dynamic process, the attributes col1, col2, col3 will be unexposed so you need to expose them manually using the AttributeExposer.
+6- Supporter
Can you share a sample of your input? When I recreate a CSV of your screenshot I can configure the reader this way, so I wonder how your sample looks like.
Yes, this is my settings :
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.