Experience Level: Beginner
Course Description: Depending on the source data can come into Alteryx in different formats. Numbers can be integers, bytes, doubles. Dates can be strings. This session covers how data comes into Alteryx, how to easily change the data types (including automatically!) and best practices for working with data.
You’ll Learn How to:
I first thought it was my wifi reception. I missed the V and V_W string too. I assume V_String is Variable string and V_W is Variable Unicode string so the Variable string actually does not support Unicode. Not sure what the V_String: Force is for. I assume it is type conversion. Does V_String Force support Unicode though?
Hi! Currency is not a data type and it's usually formatted in the front-end layer. You can format your value as currency in a Report, for example.
You usually setup the field as float, double, fixed decimal or Integer and then you format your field when presenting it.
I hope I have helped.
You are welcome! Think about this more as a database than an Excel file.
You cannot find a current data type in SQL Server for example, you must format your data wherever you are going to use the data... Excel basically format the number as currency, but we cannot say it's an original data type.
I hope I have clarified.