Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
MOliva1607097091
Contributor
Contributor

add rows to an output table on tmap

how can I start from a table with X rows and get one with Y?

for example I want to put in the tmap a variable like:

if row1.month == "January" write the date of 31 days in the output table, from January 1st to 31st, on 31 different rows.

Is it possible?

Labels (3)
3 Replies
Anonymous
Not applicable

Hi

tMap can not generate extra rows, you can try to use tLoop+tFixedFlowInput to do it, can you show us an example to explain your requirement? In this way, we can give you more details and suggestions.

Regards

Shong

MOliva1607097091
Contributor
Contributor
Author

HI!, thank you for the answare.

 

my task is to take the consumption in kWh of a month and calculate the daily consumption using the daily percentage. in the output table write the daily consumption for every single day of the year (as in the second excel sheet that I made by hand only for the first two months as an example). sum up the daily consumption month by month and check if it coincides with the monthly consumption of the input table.

 

unfortunately I can't post both excel files but I leave you an image of how the output should be for the firts month.

 

0693p00000AasQWAAZ.png 

MOliva1607097091
Contributor
Contributor
Author

ok, I'll leave you the output file here for the first two months