Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dynamic output without fetching path from data

vj28
8 - Asteroid

Say I have three files : file1.xlsx, file2.xlsx, file3.xlsx

 

I want to copy data from a specific range in file1 and paste it into file2. But the path to file2 keeps changing (modified by end user before running the workflow) and is stored in a cell in file3. Note that the name, schema and the range to be copied to stay the same so basically everything about file2 stays the same except it's location. So I need to fetch the path of file2 from file3 and output the data into it. 

 

But I can't use the "get file name from field" feature of the output tool because I don't want to append the file name/file path to the data since I don't need that extra data being copied into file2.  

 

How do I go about doing this?

 

1 REPLY 1
CoG
14 - Magnetar

Wouldn't you still just use the "Take File/Table Name From Field":

CoG_1-1752605469510.png

 

Just make sure that "Keep Field in Output" is unchecked.

Labels
Top Solution Authors