Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

How do i align data in right alignment.

PatilAmar
6 - Meteoroid

 

 

Input Format

 

Availment_AmtAvailment_amt_USD
456,56.89456,56.89
564,.67.7845,879.90
4,567.75,764.78

 

output 

Availment_AmtAvailment_amt_USD
                                                                                        456,56.89 456,56.89
                                                                                        564,.67.78 45,879.90
                                                                                         4,567.7  5,764.78

 

Hii Community,

Can anyone help me on the above example,  two columns are there Availment_Amt and Availment_amt_USD  but i only want Availment_Amt columns data to be in the right aligned as shown in the output table rest all columns should be in left aligned except Availment_Amt column , so anyone can explain me how it would be possible in alteryx ,which tool i have to use for getting output table.

 

 

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

The Table tool has the ability to set alignment - click on the column and set your alignment however you want!

Qiu
21 - Polaris
21 - Polaris

@PatilAmar 
A quick sample as suggested by @alexnajm ,then we can use the Render tool to generate the Excel file.

0527-PatilAmar-A.png0527-PatilAmar-B.png

 

Labels
Top Solution Authors