A place for Apptio product users to learn, connect, share and grow together.
Applies to:
- Datalink 4
- R11
In some cases a user may want to set a custom or generic name on a column which is uploaded via datalink with a new month named column.
To resolve this:
1. Disable validation check on Connector DOC-5813
2. Disable validation check on Dataset
3. Set Date filter to "Column filter" and Date column name to some generic value like Amount. Save and after calculation you should see a renamed column name.
- R12
1. Uncheck Enable data validation in the data set import step.
2. Add a Unpivot step and Unpivot by Azure Service Commitment and Currency Code.
3. Add a Hide and Rename step and hide Collapse Column and rename Collapse Value
This will transform the table to a generic column instead of a monthly column name.