Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Formatting data to stay as input

CherylH
8 - Asteroid

Hi everyone,

 

I receive data that numbers and text Example:  103330E, 24424001.

 

Need Alteryx to not change it and then I also need to lookup off of it. 

 

Formatted to V string under select tool but it drops the E..  Error is 103330E lost information in translation.  

 

What format should I use so Alteryx will keep data in column as input?

 

Thanks in advance. 

1 REPLY 1
nagakavyasri
12 - Quasar

Check the Size of V_string you have given, increase the size

 

Screenshot 2023-06-14 133001.png

Labels
Top Solution Authors