Attribute Name Format Limitations in Hyper Writer

The $ character might be a special character for the Hyper writer. Every format has its limitations in that regard, some more than others and I agree it would be great if there would be some documentation available on this.

I understand some formats have limitations, but what seems to have no logic here is Tableau, that uses Hyper files as native/preferred format allows the symbols in the field names but the FME Writer to this format does not. This seems like a flaw in the code that created the Writer for Hyper in FME to not handle this.

Agreed! There’s a similar situation with other writers such as writing to an SDE. The SDE allows “.” in the field name, but FME writer changes “.” to “_”, and does not write to that field as a result. Has this been addressed anywhere?

Hi ​@kumudan! The SDE case you're describing is worth exploring on its own. The Hyper writer and SDE writer have pretty different behavior under the hood.

I'd recommend creating a new post. It'll help you get more targeted answers and better visibility from anyone else running into the same thing. If you can share what FME version you're on, whether you're writing to an existing table or creating a new one, and ideally a screenshot of the key parts of your workspace (or a sample FMWT), that'll give folks a lot to work with.