Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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