Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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