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.
I am hoping someone could direct me to the right place. I can't find any other reference (I know, someone will have a link to something similar) but I am sorry I did not find anything.
My question is: I have a variable/Column defined "File_Name" as "H:\tmp\Alteryx\tmp\"+[Cycle]+ " Test.xlsx|||Sheet1". I am trying to use it the 'Write to File or Database" field when outputting my data to excel.
When I use the same string "H:\tmp\Alteryx\tmp\Cycle 5 Test.xlsx|||Sheet1" in the "Write to File or Database" it works.
I tried a simple version of this and it seems to write a file fine with my hard coded location and with a generated location. If your [Cycle] variable is a number you may have to convert it to a string?
Thank you! That will work if I am renaming the entire file. However, I am using the feature you outlined below to generate multiple tabs containing other variable names. In other words, I have a column called Type that is saved as a separate sheet for each value. But I need to use column File_Name to save the entire name of the file containing another variables "Cycle" that is also calculated within the workflow.