I have a sheet which contains Name, Location and Time in minutes
I want to sum all value which contains for example "rec" location
The result for example should be
I was trying to make InputExcel then a Tmap with expression (row1.Location.contains("REC"), but im getting null pointer exception
Can someone help me?
Solved! Go to Solution.
I tried this, the error stops but nothing is shown by tlogrow, just empty lines
About using tAgregateRow using Location is not fullfit for my job because in some Cases Locations Is not the same
For Example: XXXX REC, YYYY REC, 1111 REC
connect to tFilterRow ( Use advance Option) Condition row1.Location !=null && row1.Location.contains("REC")
Connect to tJavaRow , add additional Column hardcode the value "REC"
connect to tAggregateRow , Group on new column created above
Output on Location as 1st , and NUmber_aten as Sum.
you will get 1st record as Location and sum of all REC.
@iansoares ,please find the attached job,which was working for your scenario.
|Assunto||Tempo total gasto|
|ID:00010 (Subtarefa) - KPQ - PLANTÃO - MAN - DISPLAY- DT||60|
|ID:00005 (Subtarefa) - KPQ - PLANTÃO - HO - ROTINA MATINAL - 02/02/2019 - DT||60|
|ID:00023 (Subtarefa) - KPQ - PLANTÃO - RBO - DISPLAY - DT||120|
|ID:00026 (Subtarefa) - KPQ - PLANTÃO - JDS - LINK da Projeção - DT||40|
|ID:00029 (Subtarefa) - KPQ - PLANTÃO - FOR - cartão TEF - DT||40|
|ID:00347 (Subtarefa) - KPQ - PLANTÃO - MAN - servidor Arena - DT||40|
|ID:41432 (Subtarefa) - KPQ - PLANTÃO - REC - Impressora - DT||60|
Why i should expect in output
|Location Code||Tempo total gasto|
No man, the input is the same i sent you, only works when entering , i really dunno why this is happening, i will try to use substring
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema