Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to Convert Integer to Dimension like in Tableau

Mwatts23
8 - Asteroid

Hi,

 

I hope you can help me and I'm kind of puzzled about it on how to do it in Designer. In the screenshot from Tableau, I still need to manually convert my "Path Order" field from Measure to Dimension to get the Default Data Type = "Number (whole)".

 

Mwatts23_0-1651767883467.png

 

Originally in Designer, "Path Order" field data type is Int16 and automatically categorized as Measure in Tableau. What is the correct data type in Designer that I need to used in order for my "Path Order" to be recognized automatically as Dimension with a Default Data Type = "Number (whole)" in Tableau?

 

Thank you!

Michael

2 REPLIES 2
alisonpitt
11 - Bolide

Hi @Mwatts23 I don't think you can do what you're after, since Tableau automatically interprets numeric data as measures. There's more information on their website.

 

I think you probably have two options:

  1. specify data type as Int in Alteryx (will import as Measure) and manually change to Dimension in Tableau (which sounds like what you're doing now)
  2. specify data type as String in Alteryx (will import as Dimension) and manually change to Number (whole) in Tableau

I'm curious to see if anyone else has a workaround for this.

Mwatts23
8 - Asteroid

Thank you @alisonpitt for sharing your idea. You are right I used the option 1 you mentioned. I hope someone in the community will have a workaround on this because it will be a very big help when we want to have a live data in Tableau instead of an extract and doing the manual process.

Labels