The Data Interpreter applies to the entire data connection, so once it's applied it strips out the header information that you want (but does make the rest of the data easy to get to!)
But, you can connect to the same file twice; once using the Data Interpreter and once not. That allows you to get the Period information you want and then join that into the table data from the Data Interpreter, something like this:
I've attached a packaged fow (.tflx) file so you can see the details on how I did it.
Hope that helps!
Get Period Header.tflx 2.1 MB
Thank you for looking at this and going to the trouble of posting a solution. Have been out of the office a couple of days, but will check it out properly today.