Format Text File where Column Names are Repeated on Each Row

Hi Tim, Did you try a SchemaScanner? You don’t need to expose attributes for dynamic writing. 

I got this written out to Excel: 

Note that the fields are sorted alphabetically.

Nice ​@DanAtSafe - are you going to add this to the FME Hub as a new transformer?!

I vote yes! This is an elegant solution. Something I will definitely use down the road (or run into and have to solve at that point :D)

Hi Dan,

Thank you for the excellent solution—it worked perfectly for my needs.

The real “aha” moment for me was your use of the AttributeManager to set the field name from List value (0) and the data from List value (1). That approach had never occurred to me, and I likely wouldn’t have thought of it on my own.

I also noticed that the dropdown list for “Output Attribute” doesn’t show Lists as an option. If there’s a way to include Lists in that selection, it might help others realize that list values can be used as output attribute names. That could make this powerful technique more discoverable.

Thanks again!

Since it’s effectively json, you can just use a json flattener

Hi Ebygomm,

Thanks so much for the suggestion!

Yes, that works—as long as I wrap each line in curly brackets { }. Thankfully, that's easy to do using the StringConcatenator.

Without the curly brackets, the JSONFlattener rejects the input. Not being very familiar with JSON, this was another option I hadn’t considered.

Really appreciate the help from everyone—thank you!

You can add the brackets directly in the JSON flattener if you use the text editor when setting the JSON document as in the screenshot.