topic Data Type for a GL String in Alteryx Designer Desktop Discussions

Data Type for a GL String

nwilder — Mon, 13 Sep 2021 13:12:46 GMT

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!

Re: Data Type for a GL String

atcodedog05 — Mon, 13 Sep 2021 13:16:42 GMT

Hi @nwilder

Did you try setting it as string datatypes like V_String.

Re: Data Type for a GL String

atcodedog05 — Mon, 13 Sep 2021 13:19:39 GMT

Hi @nwilder

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

Ouput:

Hope this helps : )

Re: Data Type for a GL String

nwilder — Mon, 13 Sep 2021 13:31:30 GMT

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?

Re: Data Type for a GL String

atcodedog05 — Mon, 13 Sep 2021 13:33:50 GMT

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.

Hope this helps : )

Re: Data Type for a GL String

nwilder — Mon, 13 Sep 2021 13:39:14 GMT

That does it! Thanks a bunch!