Is there a way to add new row items with new information in existing tables in TBM studio where we do not need to manually add this into excel/csv but directly add in TBM studio, new columns addition is not required but new row addition is needed.  Is there any way of function exist in TBM studio, if yes please help.
#CostingStandard(CT-Foundation)

Hi @Bhupendra Singh Sisodiya, the only way I've done this in the past is by creating another table, and then adding an append step to the source table and pulling in the other table that way.  ​​There's also editable tables, too, that could be used.
Original Message:
Sent: 02-17-2022 11:52
From: Bhupendra Singh Sisodiya
Subject: Can we add row items or new row in existing Table via any functions

Is there a way to add new row items with new information in existing tables in TBM studio where we do not need to manually add this into excel/csv but directly add in TBM studio, new columns addition is not required but new row addition is needed.  Is there any way of function exist in TBM studio, if yes please help.
#CostingStandard(CT-Foundation)

@Bhupendra Singh Sisodiya
Yes, we use the Append step all the time, as mentioned by @Jenny Franklin. For example, to add mapping tables from the three main cloud service providers (AWS, GCP, Azure) to the main one, that has also private cloud entries.​​

------------------------------
Regards, Guillermo
------------------------------

Original Message:
Sent: 02-17-2022 14:22
From: Jenny Franklin
Subject: Can we add row items or new row in existing Table via any functions

Hi @Bhupendra Singh Sisodiya, the only way I've done this in the past is by creating another table, and then adding an append step to the source table and pulling in the other table that way.  ​​There's also editable tables, too, that could be used.
Original Message:
Sent: 02-17-2022 11:52
From: Bhupendra Singh Sisodiya
Subject: Can we add row items or new row in existing Table via any functions

Is there a way to add new row items with new information in existing tables in TBM studio where we do not need to manually add this into excel/csv but directly add in TBM studio, new columns addition is not required but new row addition is needed.  Is there any way of function exist in TBM studio, if yes please help.
#CostingStandard(CT-Foundation)

In 11 you could append to existing data but that is not a manual option in 12. You can use Datalink Classic to append still but if you are not using Datalink, I wouldn't recommend using it just for that purpose.
Original Message:
Sent: 02-17-2022 11:52
From: Bhupendra Singh Sisodiya
Subject: Can we add row items or new row in existing Table via any functions

Is there a way to add new row items with new information in existing tables in TBM studio where we do not need to manually add this into excel/csv but directly add in TBM studio, new columns addition is not required but new row addition is needed.  Is there any way of function exist in TBM studio, if yes please help.
#CostingStandard(CT-Foundation)

I hadn't thought about that scenario, @Robert Krauss.
 
Another option-arguably a long shot-would be using editable tables, where you could copy & paste the new rows as you would in Excel (more or less).​

------------------------------
Regards, Guillermo
------------------------------

Original Message:
Sent: 02-18-2022 11:44
From: Robert Krauss
Subject: Can we add row items or new row in existing Table via any functions

In 11 you could append to existing data but that is not a manual option in 12. You can use Datalink Classic to append still but if you are not using Datalink, I wouldn't recommend using it just for that purpose.
Original Message:
Sent: 02-17-2022 11:52
From: Bhupendra Singh Sisodiya
Subject: Can we add row items or new row in existing Table via any functions

Is there a way to add new row items with new information in existing tables in TBM studio where we do not need to manually add this into excel/csv but directly add in TBM studio, new columns addition is not required but new row addition is needed.  Is there any way of function exist in TBM studio, if yes please help.
#CostingStandard(CT-Foundation)

There is a way to add new rows into a existing data set.
Look at the SplitEx function.
This function can create a new line from a record, a bit like the LookupEx function but without the lookup.

Regards,

Robert
#CostingStandard(CT-Foundation)

Hey Bhupendra,

You may want to create an editable table and have the transformed version of the editable table appended into your main table.  For those ad hoc rows, you can insert them into the editable table and refresh the transform table with your data.  This will allow you to manually add rows within Apptio.  Feel free to reach out if you have any questions around this.

------------------------------
Eric Chan
Rego Consulting
------------------------------

Original Message:
Sent: 02-17-2022 11:52
From: Bhupendra Singh Sisodiya
Subject: Can we add row items or new row in existing Table via any functions

Is there a way to add new row items with new information in existing tables in TBM studio where we do not need to manually add this into excel/csv but directly add in TBM studio, new columns addition is not required but new row addition is needed.  Is there any way of function exist in TBM studio, if yes please help.
#CostingStandard(CT-Foundation)

@Eric Chan

This solution does not answer the question.
Its about adding a row via a function not a manual action.

Cheers.
Original Message:
Sent: 02-21-2022 14:43
From: Eric Chan
Subject: Can we add row items or new row in existing Table via any functions

Hey Bhupendra,

You may want to create an editable table and have the transformed version of the editable table appended into your main table.  For those ad hoc rows, you can insert them into the editable table and refresh the transform table with your data.  This will allow you to manually add rows within Apptio.  Feel free to reach out if you have any questions around this.

------------------------------
Eric Chan
Rego Consulting

Original Message:
Sent: 02-17-2022 11:52
From: Bhupendra Singh Sisodiya
Subject: Can we add row items or new row in existing Table via any functions

Is there a way to add new row items with new information in existing tables in TBM studio where we do not need to manually add this into excel/csv but directly add in TBM studio, new columns addition is not required but new row addition is needed.  Is there any way of function exist in TBM studio, if yes please help.​
#CostingStandard(CT-Foundation)

True, @Robert Brilmayer, @Bhupendra Singh Sisodiya. SplitEx() or LookupEx() will add rows to the table. Probably an Unpivot step too. If we had a more concrete example, we could provide a more definite solution, e.g. a list of sample data and what you would want to add to the table.​​

------------------------------
Regards, Guillermo
------------------------------

Original Message:
Sent: 02-21-2022 17:52
From: Robert Brilmayer
Subject: Can we add row items or new row in existing Table via any functions

This solution does not answer the question.
Its about adding a row via a function not a manual action.

Cheers.
Original Message:
Sent: 02-21-2022 14:43
From: Eric Chan
Subject: Can we add row items or new row in existing Table via any functions

Hey Bhupendra,

You may want to create an editable table and have the transformed version of the editable table appended into your main table.  For those ad hoc rows, you can insert them into the editable table and refresh the transform table with your data.  This will allow you to manually add rows within Apptio.  Feel free to reach out if you have any questions around this.

------------------------------
Eric Chan
Rego Consulting

Original Message:
Sent: 02-17-2022 11:52
From: Bhupendra Singh Sisodiya
Subject: Can we add row items or new row in existing Table via any functions

Is there a way to add new row items with new information in existing tables in TBM studio where we do not need to manually add this into excel/csv but directly add in TBM studio, new columns addition is not required but new row addition is needed.  Is there any way of function exist in TBM studio, if yes please help.
#CostingStandard(CT-Foundation)