Free Trial

Alteryx Designer Desktop Discussions

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

Basic Table not keeping Field settings for data types

sammyb84
8 - Asteroid

I am trying to do a couple of things for some output files.

 

  1. Needing to format the Headers of certain columns only - I have accomplished this
  2. I need to output based on File name ( a formula field to create multiple files based on a grouping) - I have accomplished this
  3. I need to keep the formatting (data types) of all fields ( for some reason the Basic Table is changing the field setting to max of 6 decimal places)  - failing

I need to know if there is a way to get around basic table only allowing up to 6 digits or not change this at all

Before Basic Table

sammyb84_0-1666124921712.png

 

After Basic Table

 

sammyb84_1-1666124990532.png

 

 

 

 

2 REPLIES 2
sammyb84
8 - Asteroid

Sorry Nevermind.  I changed my data type to string and that solved the problem

grazitti_sapna
17 - Castor

@sammyb84 , also if you are using table tool then u can set the decimal places in the configuration as below:

 

grazitti_sapna_0-1666158002667.png

or you can use select tool and change data type to fixed decimal and set it to 6 decimal places as below:

 

grazitti_sapna_1-1666158095422.png

 

Sapna Gupta
Labels
Top Solution Authors