We are using reports to export data for our product and have come acress a need to use text_agg() in one of the columns to stop duplicate rows. This good (we need the aggregated data) but it would be nice to extend this to supprt a delimeter type like we have in Join(text field, delimiter) which is not available in Reports. As ware exporting a CSV it would be nice to be able to for example use | as our delimter in these columns. I know I can make a new field in the DB and use that which I will do for now but thought I’d post this anyway.
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
Is there a 'join' function in the reports? | 3 | 22 | October 14, 2024 | |
CSV Import with hurdles (Delimiter?) | 13 | 188 | August 11, 2023 | |
For Field Mapping operations (CSV import, later type conversion) add formula field for concatenating data | 0 | 255 | October 1, 2022 | |
How to use fields from references in reports? | 3 | 232 | February 2, 2023 | |
Error in report calculation / Hierarchical data in Reports | 3 | 24 | August 21, 2024 |