aggregatetalend
Talend tAggregateRow put same grouping into different rows
A screenshot of my output in tLogRow:
tmap settings:
taggregaterow settings:
the workflow:
What I want to do is grouping by "fckd_operator" and "fdtgl_pinjam", but as you can see, "wiros" and "08-2015" aren't being grouped correctly
Any ideas?
EDIT 11/29 -> adding workflow,tmap, and taggregate row screenshot
Solution
I don't know if this only happens on my machine, but it is kinda stupid.
In my tmap settings, you can see that I use pattern "yyyy-MM" to format fdtgl_pinjam, but it seems that pattern in tmap date only affects the outputted text and not the value, hence make the grouping seems wrong.
My workaround is:
- remove the pattern in tmap settings
- using fdtgl_pinjam once more in tmap, but the value is Talend.getFirstDayOfMonth(fdtgl_pinjam), and group them using this field
It works now! :D
- Is there a product operator (or work around) in SQLite?
- F# iterate sequence of objects and conditionally aggregate based on property
- Why does summing data grouped by df.iloc[:, 0] also sum up the column names?
- Aggregator tool for bug/issue trackers?
- Calculate means across elements in a list
- Convert a "by" object to a data frame in R
- Logstash field is never shown after aggregation
- SQL aggregate whether table contains a category or type of record
- Mongodb Aggregration merge not working with archived data restore
- Multiple aggregations of the same column using pandas GroupBy.agg()
- the created_at search in prisma aggregateRow mongodb does not work
- Filtering a pivot to only include columns with data [Snowflake]
- Multiple STRING_AGG in one query
- Aggregate into custom groups
- R - add column to dataset with number of times that a row value is repeated
- When an aggregate inherits from an aggregate, is there risk of object slicing or memory leaks?
- Max Value in a Data Frame with Groupby using idmax()
- polars aggregate list[str] column into set[str]
- Pandas missing value representation in aggregated dataframe
- Create column of current balance in PySpark
- Polars rolling only retains index and by columns
- Solution for SpecificationError: nested renamer is not supported while agg() along with groupby()
- Can I perform a bit-wise group by and aggregation with Polars `or_`?
- Trying to join two collections together, array in collection map to other collection. MongoDB
- Oracle SQL hierarchical query data accumulation
- mongodb aggregate get current date
- How to null-safe and missing-field-safe determine max length of field in mongodb?
- SELECT rows with the max count per column value after GROUP BY
- Multiple aggregations on multiple columns in Python polars
- Sum across columns of the same name (or "key") in polars dataframe