GitHub user Qunovaganesh edited a discussion: Right set of transform for actions based on satisfying multiple conditions.
Hi Enthisiasts, Greetings. We are having a use case here. Request if you could suggest the right set of transforms for doing this. Please consider that we have 2 files with identical headers to compare and basis the match or otherwise of two or more fields in each of the files, we want to send the records to two different buckets. We have tried filter transforms. But it is a step by step approach and hence doesn't work. eg: If the name matches, the filter transform sends the record to bucket 1. But what if the GST and phone for this record doesn't match. And in this case, I would want to send it to bucket 2. We want to send the records to the buckets basis the column scenario below. We tried Merge rows Diff transform too. But unable to get the desired output mentioned in the action column. Your guidance shall go a long way.  Regards Ganesh GitHub link: https://github.com/apache/hop/discussions/4683 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
