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
- mongodb aggregate get current date
- Polars rolling only retains index and by columns
- 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
- I need to merge base record data with two layers of edits in different collections
- MongoDB update document property array of strings $push if not present $pull if present
- Fastest way to count occurrences of each unique element
- Can I perform a bit-wise group by and aggregation with Polars `or_`?
- How do I use Pandas group-by to get the sum?
- R sports dataframe - combining and aggregating data in several columns
- Pivot on multiple columns in snowflake
- Excel - Increment a counter if data is found
- Performing a query on a result from another query?
- Pandas: Returning Blank Array after Groupby Aggregate
- How To Query Unknown Key's Value Documents With Nested Structure in MongoDB?
- How to make a multiple match into an aggregate comparing the full string on MongoDB?
- Mongo DB Aggregate => Lookup => combine lookup data property into root property array
- Debounce Wordpress action hook (or any other PHP function)
- Designated initializers in C++20
- How to write a Case() SQL expression with an aggregated field (Sum) using Django's query builder
- polars equivalent of pandas groupby.apply(drop_duplicates)
- polars aggregate list[str] column into set[str]
- Show aggregated values breakdown in a separate column?
- Aggregate multiple variables with different functions
- Aggregate / summarize multiple variables per group (e.g. sum, mean)
- How to optimise an aggregation function with conditions?
- mongoDb:Cannot find index to verify that join fields will be unique
- Calculate multiple aggregations on several variables