Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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