Smart Tile for multiple fields in Alteryx

[hainguyen281998]

My data set contains around 100 numeric fields. For each of these field, I want to apply Smart Tile to categorize them as Extremely High, High, Above Average, Average, Below Average, Low and Extremely Low. How can I apply Smart Tile to all 100 fields simultaneously?

[apathetichell]

add a recordid.

transpose your numeric columns.

add your tile tool.

output your verbose names of your [Value] field.

group by [Name]

[Raj]

@hainguyen281998 
another method

1. Input Data: Start with an input tool to bring in your dataset containing the 100 numeric fields.

2. Transpose Tool: Use a Transpose tool to convert your dataset from wide to long format, so that each numeric field becomes a single row.

3. Formula Tool: Add a Formula tool to create a new field that calculates the Smart Tile value for each numeric field. You can use conditional statements within the Formula tool to assign the appropriate category (Extremely High, High, Above Average, Average, Below Average, Low, Extremely Low) based on the Smart Tile value.

4. Transpose Tool (optional): If needed, use another Transpose tool to convert the dataset back to its original wide format.

5. Output Data: Finally, use an Output tool to export the dataset with the Smart Tile categories applied for each numeric field.
   
   formual to use
   eg-
   IF [NumericField] >= SmartTile(0.9) THEN "Extremely High"
   ELSEIF [NumericField] >= SmartTile(0.7) THEN "High"
   ELSEIF [NumericField] >= SmartTile(0.5) THEN "Above Average"
   ELSEIF [NumericField] >= SmartTile(0.3) THEN "Average"
   ELSEIF [NumericField] >= SmartTile(0.1) THEN "Below Average"
   ELSEIF [NumericField] >= SmartTile(0.05) THEN "Low"
   ELSE "Extremely Low"
   ENDIF
   
   hope this helps.
   
   

[hainguyen281998]

Thank you. I tried that and it work. At step 4, I used Cross Tab instead of Transpose to convert the dataset back to its original format.