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?
Solved! Go to Solution.
Wouldn't you still just use the "Take File/Table Name From Field":
Just make sure that "Keep Field in Output" is unchecked.
User | Count |
---|---|
107 | |
82 | |
69 | |
54 | |
40 |