Alteryx Designer Desktop Discussions

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

Data Type for a GL String

nwilder
6 - Meteoroid

Hello,

 

One column of my Input Data contains GL Strings (ex: 101.0000.0000.615012.000.0000.000) 

 

I would like to output the full GL String in my output file but it seems like no matter what data type I assign to it, some of the trailing zeros still are cut off.  

 

I have been using the Select Tool to assign data types.  Any ideas of what tool to use and/or data type to assign in order to keep the full GL string?

 

Thanks for the help!

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @nwilder 

 

Did you try setting it as string datatypes like V_String.

atcodedog05
22 - Nova
22 - Nova

Hi @nwilder 

 

I am able to get the whole string. Can I know what is the issue you are facing.

 

Ouput:

atcodedog05_0-1631539151672.png

 

Hope this helps : )

nwilder
6 - Meteoroid

Hi there, thanks for the quick reply, After doing more digging I believe the issue occurs when I create a Table (it cuts off the data string).  Any ideas where in the table settings I can change this?  

atcodedog05
22 - Nova
22 - Nova

Hi @nwilder 

 

This might be because the page layout width is insufficient. Please increase page layout width in render tool refer the below-highlighted option.

atcodedog05_0-1631540007601.png

 

Hope this helps : )

 

nwilder
6 - Meteoroid

That does it!  Thanks a bunch!

Labels