RE: Altair SLC iterating over a pseudo column that contains both numeric and character data
Too long to post here, see github
github
https://github.com/rogerjdeangelis/utl-altair-slc-interating-over-a-pseudo-column-that-contains-both-numeric-and-charater-data
community.altair
https://community.altair.com/discussion/60998
https://community.altair.com/discussion/60998/monarch-classic-is-there-a-way-to-create-an-if-formula-to-return-a-blank-value?tab=all
PROBLEM Convert "text" to " " in mixed type column (pyhton can also do this)
INPUT
Column list
[1] 1
[1] "text"
[1] 3
OUTPUT
New Column lst
[1] 1 still numeric
[1] " " still character
[1] 3 still numeric