Start Free Trial

Alteryx Designer Desktop Discussions

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

How can I convert year 2,022 into 2022 in the Basic Table Tool?

Kinetic_analytics
11 - Bolide

Hello:

How can I convert year 2,022 into 2022 in the Basic Table Tool?

Kinetic_analytics_0-1674499209082.png

Appreciate your help.

Thanks

6 REPLIES 6
ShankerV
17 - Castor

Hi @Kinetic_analytics 

 

Are you expecting the output like below.

 

ShankerV_0-1674499543744.png

 

 

binu_acs
21 - Polaris

@Kinetic_analytics you should remove the ',' before the table tool from the field year

binuacs_0-1674499542825.png

 

Kinetic_analytics
11 - Bolide

@ShankerV yes

ShankerV
17 - Castor

|Hi @Kinetic_analytics 

 

Great, please use the attached workflow.

If any more questions, please post.

 

 

Kinetic_analytics
11 - Bolide

@ShankerV Thank you. Smart solution. I did not thought about in this way. :) Appreciate your help in my learning process.

Kinetic_analytics
11 - Bolide

@binu_acs Thank you. Good one :) 

Labels
Top Solution Authors