DSXchange

One of our consultants had a interesting trick to combine the rows, basically use a transformer with a stage variable to create an ever growing concatenated string followed by an aggregator stage with a LAST function to get the final concatenated value as a single row.

One thing to remember is that a hash file is a Universe database file. That means you can have other jobs using the Universe stage to do SQL queries on the hash table. You can then export the query into a flat file.