You may want to work around this
by choosing Vertical Bar as a Field Separator.
This would collapse all your fields into a single one
(please be sure that you have no | in your data :-).
Then you could parse this huge string
into your fixed-width fields
using similar calculations like this:
// this would be your Field1
// this would be your Field2
Looks tedious, but it works at least.
Hope this could help.
Thank you, Yuri!
So, basically, there are no Tableau settings that make schema.ini having precedence over the 'file properties' configurations?
Not sure if Tableau is actually reading shema.ini file
when connecting to Text files using it's native driver.
A schema.ini file is a Microsoft configuration file associated with the Microsoft JET engine.
It tells JET how to interpret the contents of text files, including data structure, date formats, and other settings.
It is mentioned in regard to the Custom Geocoding,
but I suppose it's generally applied.
If you're on Windows, could you try to use MS Jet (Legacy Connection)?
Tableau gets field names and data types from the schema.ini file but ignores the Width. I thought I'm missing something in settings. If not, it might be a bug.
I have a possibility to implement ETL externally. I'll do that if nothing else helps.
Elena, you're welcome.
Please let me know about the solution (if any).