This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
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.
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?
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.