Output field names even if record count = 0

poles1c

Hi,

I am reading in a fixed width file that has header,detail record, and trailer components,I ultimately want to write these to HDFS. If the detail record component has 0 records there will be no output for the associated Alteryx field names. I need to output all fields even if there aren't detail records in the fixed width file. Anyone have a clue how I might go about this?

Thanks!

Courtney

RodL

Can find a specific example, but (from memory) one technique I've seen is to create a Text Input tool with a single record of NULL values in the fields.

You can then Union that with the existing workflow (which will then provide at least one row of data). You of course then don't want that record in your data if you actually do have data, but again from memory, if you order the Union to first take the "real" data and then union the "fake" record data, you can test in a to see if the first record has NULLs and if not, then filter out all NULL records (which would be the one at the bottom out of the Union).

Sorry it's not more exact, but thought I'd at least throw this out as something you could try. :-)