Alteryx Designer Desktop Discussions

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

Seeking for advice - some tidy up of a final output

BillyMOK
5 - Atom

Dear Expert 

 

I use Alteryx to draw a workflow and I get my output. It is ~99% of my existing file handled by excel. 

But I have a question in some format tidy up. eg change the text form to number. 

I get the Alteryx output and requested format in excel. 

Since some data is sensitive, may I send the file to you by email to seek for advice instead of attach the file in this open area?

Pls give me a hand. 

 

Regards

Billy 

5 REPLIES 5
mbarone
16 - Nebula
16 - Nebula

do you have any screen shots or files you can share?  not quite understanding what  you're asking for here.

BillyMOK
5 - Atom

Hi Mbarone

 

In my output file, I would like to convert it to number. Can you share with me can I use some Alteryx tool to do it? Thanks!

 

 

BillyMOK_0-1605749404099.png

 

Qiu
20 - Arcturus
20 - Arcturus

@BillyMOK 
By any chances, you are outputting the data as Int64?

BillyMOK
5 - Atom

HI Qiu 

 

Thank you 

 

Let me try

 

Regards

Billy 

mbarone
16 - Nebula
16 - Nebula

As @Qiu mentioned, make sure your data types are set in Alteryx via the select tool to whatever type you need it to be (int, double, fixed decimal, etc.). 

Labels