Field info tool detects everything as vstring
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
rumpa
5 - Atom
‎10-23-2023
04:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to create a DQC on input file format. input file is in .csv format. the sample file has only 57 rows. I am trying to use Field info tool to detect datatype of each field. But all numeric fields or dates fields are detected as Vstring. Need some help to overcome this issue.
Labels:
- Labels:
- Data Challenge
1 REPLY 1
17 - Castor
‎10-23-2023
06:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can add an Auto Field tool after your input to see the closest approximate match of data type which Alteryx thinks is appropriate. Do you have some sample data?
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
