Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hello,
Inputting an .xlsx file, (a downloaded report) have a column named "Check Number" that reads in as a V_WSting. Need to convert it so a Number but the usual tools, Data Cleansing, ToNumber() does not work. Get the error: ConvError: Select (4): Check Number: 25654 is not a valid number. When looking at the cells in the Input Preview window there are small white and black pins at the start and end of the data. What are these? How do I get rid of them so I can make the field a Number? Thank you
