Can I generate a .txt file with fixed width columns and column headers?

JonasLundstrom8

04-01-2017

Hello,

 

I am currently importing and reconciling a .txt file from an external source, after processing, part of the content needs to be exported again.

My problem stems from the formatting, the file needs to adhere to the same format as the imported file. Which is not a problem using 1219536_pastedImage_0.png

However when I use the above settings I lose the column headers. I have tried to modify the xml-source:

1219537_pastedImage_2.png

saveTitle according to documentation is the attribute that declares the column header, however the format attribute:"fixed" seems to override any such tampering.

Using the basic Text export which allows you to select via checkbox first line as column header is not looking like a viable option since the columns are of various widths without a uniform separator and modifying the incoming file is not possible. Any tips to work around this? I was looking into creating a file via a javascript activity in some sort of filestream but have not found anything that works.

 

Thanks for you time.

/Jonas L

Accepted Solutions (1)

Accepted Solutions (1)

florentlb

17-01-2017

Hi Jonas,

Just got confirmation that the product team is aware of the improvement possibilities for this option but it seems that there is no known workaround at the moment to directly add a header to the file.

I'll keep you updated with it but as this option is not used a lot it could take several months.

Let me know if you have other questions.

Florent.

Answers (2)

Answers (2)

vasudevaraog731

09-05-2018

Hi,

We have tried the below option in data extraction activity by checking "Use first line as column header" but when the "zero" records coming from previous target it's not generating column header in Target file

Is it a Product feature?

1483797_pastedImage_0.png

florentlb

11-01-2017

Hi Jonas,

Indeed there seems to be no header options with this mode. I'm trying to get some feedback to see if this is a common practice and if there are possible workarounds.

Florent.