Export 'subject' (or in general XML field) in export template

[#1]

Hello Amit_Kumar​

I was trying above suggested solution. Although I am able to add subject field in the output column of query activity, it is not giving me the result.

Please see screenshot.

How can I extract the values in a file?

Thanks,

Chandni

[#2]

Hi All

It is often indicated that whatever workaround will be used to extract/insert subject line there is still a problem of that subject line being BEFORE personalization (so any dynamic parameters in subject will be there as plain text). 

Has anybody figured out a way to obtain the subject that is AFTER personalization step and has all the dynamic parameters changed to actual DB values?

@Jean-Serge_Biro  @Amit_Kumar