Hi,
can you define the output data type in a custom function; I thought , seemingly wrongly, you put it outside the brackets,
so
when used as an addcolumn the new column would be type number? it's not, so can it be done and what does a data type out side of hte function
Please Login or Register to view this content.
mean ? ( x as type ) as type =>
Richard.
I seem to have been right, but was expecting the column data type to reflect this.
Column data type and data type of value is separate.
For an example, column could have mixed data type (though not recommended), having number and text etc.
Value will either be specific type or untyped. Not multiple.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
Yes, I have now realized that, just as experiment had output for a number as text and so when eg X * 10 , got error,
is there a way to add the column type ? i have done it for things like this
but this works on the whole table, if you want to 'add column' i tried;Please Login or Register to view this content.
and due to the comma, 10, type , it (i think) thinks you are starting an new variable,Please Login or Register to view this content.
don't know if there is a way around this?
will marks this up, thanks for the help.
Richard.
First one should be find for adding column. You just need to invoke it within Advanced Editor.
If you want to go the 2nd route...
Don't declare type in function.
But declare it in AddColumn() where you invoke the function.
Then when you addcolumn by invoking function.Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks,
Richard.
Just be aware that doing that doesn't actually convert or validate any of the data in that column to match the type.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks