community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Some users have experienced issues with Interactive Lesson correctly tracking progress. Please use the Feedback button in the lesson to let us know if you experience this.
Watch videos on a variety of topics that range from beginner to advanced.
Videos
Watch videos on a variety of topics that range from beginner to advanced.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Live Training: Understanding Data Types

Director, Customer Enablement
Director, Customer Enablement

 

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:

  • Disseminate import data type behavior depending on the input source
  • Automatically or manually change data types
  • Implement best practices for data types

 

Date: 2018-05-29

Version: 2018.1

Presenter: @ChristineB

 

Meteor

Not sure if anyone noticed that from around 20:00 onwards when you talk about v_string and v_wstring, the video is broken and the sound is not clear.

 

Atom

Yes, even I noticed that breaking voice and couldn't understand whats V_string

Meteor

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?

Meteor

Why doesn't Alteryx have currency as a data type?

Highlighted
Atom

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.

Meteor

Thank you. Yes thank you for the work-around. Helpful but disappointed.

In simple terms, Alteryx has no native data type as a currency but there is this workaround. 

Atom

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.

Meteor

Thank you for the clarification