Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only

How to set monthly column in Azure Bill Summary to a generic name 

Mon December 04, 2017 06:10 PM

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. 

 








#Datalink

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Comments

Thu April 05, 2018 07:35 AM

Applies to:

- Datalink 4

- 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.


#Datalink