community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

How can I create only 1 output file using derived name from a field?

Atom

I am trying to name an output file using "Take File/Table Name From Field"  "Change File/Table Name" options on the configure screen. I have a formula that formats a field "[INPUT_Field_1]+"Support_TOTAL_test_"+[DateToday]" to create the file name I want using the value of the field . In the "Write to File or Database" I input the path and a file name but I want the file name from the data field.  When I run the workflow I get 2 files one with the correct name from the field and the other with the name from the field without the prefix and suffix appended. How can I stop this from happening? This is for a csv format.Annotation 2019-09-27 133718.png

Quasar
Quasar

Hello @Mikesz,

 

I think that we need a little clarification on your question. Are you saying that you have a formula that is resulting in two values in the new field? And thus, it's trying to create two files based on the two names that are being returned?

 

In this field with the unexpected file name (missing pre/suffix) are there null values in the prefix/suffix field?

Atom

I enter a file name/path in the write to file or database field.  But I create a field using a formula where I concatenate a value from another field, a fixed constant, and todays date.  [INPUT_Field_1]+"Support_TOTAL_test_"+[DateToday].  When I run the workflow I get 2 seperate files, "CASupport_TOTAL_test_092719" AND "Support_TOTAL_test_". Hope this makes sense, Thank you for input.

Quasar
Quasar

do a test. Drop a sum tool and do a count of and group by on [INPUT_Field_1]. I would bet that you have the value "CASupport_" in most of them and NULL in the rest. 

Highlighted
Atom

DUH! Yup that was it THNX!!  

Quasar
Quasar

Excellent! Anytime that something involving a formula is returning more results than I would expect I always think about null values because they make weird things happen.

 

Could you do me a favor and mark this solved so future users with this problem can find the solution quicker?

Labels