Question

Problem with AttributeFileWriter

scarter
Rank
Badge +7

I'm trialling AttributeFileWriter to output a list of values from a table from a specified attribute field. In theory AttributeFileWriter seems to be ideal for the task.

 

I've read in the source data which has 13 records. I want to create a .txt list of all the application numbers from the 'application_number' field.

 

There are no duplicate application numbers in the source data so I'd expect an output of 13 applications numbers in the .txt.

 

In AttributeFileWriter I've set the Source Attribute to application_number. But when I view the output .txt only one application numbers is listed, and not 13 as expected.

 

Any ideas as to why this is?

4 replies

david_r
Rank
Userlevel 4

Is the AttributeFileWriter configured for appending or replacing content?

Also, why not use a FeatureWriter with the Text File writer? https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/textline/TEXTLINE_writer.htm

scarter
Rank
Badge +7

Is the AttributeFileWriter configured for appending or replacing content?

Also, why not use a FeatureWriter with the Text File writer? https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/textline/TEXTLINE_writer.htm

Thanks for that, david_r. I switched to ‘Append to file’ and it now produces all 13 values. Great. Is there a way of adding a delimiter to the outputted values? Or is there a way of outputting as a list? So instead of… value_1 value_2 value_3 value_4 value_5 value_6 value_7 value_8 value_9 value_10 value_11 value_12 value_13 I would get… value_1; value_2; value_3; value_4; value_5; value_6; value_7; value_8; value_9; value_10; value_11; value_12; value_13 or to get… value_1 value_2 value_3 value_4 value_5 value_6 value_7 value_8 value_9 value_10 value_11 value_12 value_13 Thanks, value_1 value_2 value_3 value_4 value_5 value_6 value_7 value_8 value_9 value_10 value_11 value_12 value_13
david_r
Rank
Userlevel 4
Thanks for that, david_r. I switched to ‘Append to file’ and it now produces all 13 values. Great. Is there a way of adding a delimiter to the outputted values? Or is there a way of outputting as a list? So instead of… value_1 value_2 value_3 value_4 value_5 value_6 value_7 value_8 value_9 value_10 value_11 value_12 value_13 I would get… value_1; value_2; value_3; value_4; value_5; value_6; value_7; value_8; value_9; value_10; value_11; value_12; value_13 or to get… value_1 value_2 value_3 value_4 value_5 value_6 value_7 value_8 value_9 value_10 value_11 value_12 value_13 Thanks, value_1 value_2 value_3 value_4 value_5 value_6 value_7 value_8 value_9 value_10 value_11 value_12 value_13

My recommendation is to replace the AttributeFileWriter (which is a specialty one-trick-pony transformer) with the much more powerful FeatureWriter. Specifically, look into using either the Text File or the CSV writer.

The AttributeFileWriter is not really meant for what you're trying to accomplish.

scarter
Rank
Badge +7
Thanks for that, david_r. I switched to ‘Append to file’ and it now produces all 13 values. Great. Is there a way of adding a delimiter to the outputted values? Or is there a way of outputting as a list? So instead of… value_1 value_2 value_3 value_4 value_5 value_6 value_7 value_8 value_9 value_10 value_11 value_12 value_13 I would get… value_1; value_2; value_3; value_4; value_5; value_6; value_7; value_8; value_9; value_10; value_11; value_12; value_13 or to get… value_1 value_2 value_3 value_4 value_5 value_6 value_7 value_8 value_9 value_10 value_11 value_12 value_13 Thanks, value_1 value_2 value_3 value_4 value_5 value_6 value_7 value_8 value_9 value_10 value_11 value_12 value_13
OK, thanks. That works much better.

Reply


Community Stats

28,731
Posts
109,530
Replies
36,565
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.