Community & Support
Learn
Marketplace
Discussions
Categories
Discussions
General
Platform
Academic
Partner
Regional
User Groups
Documentation
Events
Altair Exchange
Share or Download Projects
Resources
News & Instructions
Programs
YouTube
Employee Resources
This tab can be seen by employees only. Please do not share these resources externally.
Groups
Join a User Group
Support
Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
Example Set Transpose to Attribute Names
miked
Hi All,
Hoping I'm missing the simple answer here but I'm trying to transpose an aggregated set of data (Sales Months) to be Attribute Names (trying to make this dynamic as the number of months varies from data set to data set). below is a screenshot of current view. I attempted to "Rename by Example Set" but ended up with an error. I assume it's from trying to make a date the attribute name when it is set up as a Nominal. Any ideas would be appreciated from the community.
Find more posts tagged with
AI Studio
Getting Started
Generate Attributes
Tutorials + Training
Dates + Times
ETL + Data Prep
Accepted answers
MartinLiebig
Hi
@miked
,
i am a bit confused about what you want? Likely you want the Sales_Month as column Names?
If so, try to set it to Role ID and then use the Transpose operator. Maybe you want to convert your dates into Nominals first.
Cheers,
Martin
All comments
MartinLiebig
Hi
@miked
,
i am a bit confused about what you want? Likely you want the Sales_Month as column Names?
If so, try to set it to Role ID and then use the Transpose operator. Maybe you want to convert your dates into Nominals first.
Cheers,
Martin
miked
@mschmitz
Hi Martin - Yes - I would like to use the Sales_Month as a column name and then perform some calcs that are month specific....Then de-pivot the data back together in stacked from. I will give your sugggestion a try thank you.
-Mike
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups