dmainou opened a new issue, #6433: URL: https://github.com/apache/hop/issues/6433
### What would you like to happen? ## [Feature Request] Concat Fields: Option to Skip Null Values ### Summary Enhance the **Concat Fields** transform to optionally **skip null field values** when concatenating multiple input fields using a delimiter. ### Problem Statement The current **Concat Fields** transform concatenates all configured fields regardless of whether individual values are `null`. When one or more fields are `null`, the output contains empty values and extra delimiters, which then require additional transforms or scripting to clean up. **(e.g. to create a well formed address)** This is a common scenario when working with partially populated records from upstream systems. ### Proposed Behaviour When enabled, the transform should: - Ignore `null` input values - Concatenate only fields that contain values - Apply delimiters only between existing values ### Examples Configured fields: `a`, `b`, `c` Delimiter: `,` | a | b | c | Current Output | Proposed Output | |------|------|------|----------------|-----------------| | a | b | c | a,b,c | a,b,c | | a | b | null | a ,b, | a,b | | a | null | null | a,, | a | | null | b | c | ,b,c | b,c | | null | b | null | ,b, | b | | null | null | c | ,,c | c | | null | null | null | ,, | null | ### Suggested UI / Configuration Add an optional flag to the **Concat Fields** transform configuration, for example: - [ ] Skip null values - [ ] Skip empty strings (optional) When disabled, the transform behaves exactly as it does today. ### Benefits - Eliminates the need for downstream cleanup logic - Reduces reliance on **User Defined Java Expression** or **JavaScript** transforms - Produces cleaner and more predictable output - Matches common expectations for string concatenation in data integration workflows ### Backward Compatibility - Feature is opt-in - Existing pipelines are unaffected unless explicitly enabled <img width="1091" height="435" alt="Image" src="https://github.com/user-attachments/assets/01d07df8-8ea1-4f22-b379-540429a88923"; /> ### Issue Priority Priority: 3 ### Issue Component Component: Hop Gui -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
