I was putting together an example workflow for knowledge sharing and noticed the table reader is unable letting me assign even string type to non-native data types.
Hi @mwiegand , I enjoy your posts as you do like getting down and dirty with the fun stuff!
That’s actually quite horrible isn’t it, lol
Your sample file though gave me a chance to try out a component I wrote a while ago, to see if it can help out in this kind of situation, as I have also in the past found that the auto type casting can only go so far without “help”.
In this demo, it eases the pain a little by succeeding in casting all columns to String, whereupon a further call to Column Auto Type Cast is able to move things on a little, at least as far as the numeric columns are concerned. (But not the booleans, dates etc)