topic Re: add rows to an output table on tmap in Talend Data Catalog

add rows to an output table on tmap

MOliva1607097091 — Sat, 16 Nov 2024 00:59:19 GMT

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?

Re: add rows to an output table on tmap

Anonymous — Tue, 08 Dec 2020 09:19:48 GMT

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

Re: add rows to an output table on tmap

MOliva1607097091 — Tue, 08 Dec 2020 12:10:14 GMT

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.

Re: add rows to an output table on tmap

MOliva1607097091 — Tue, 08 Dec 2020 12:11:27 GMT

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