Hello:
Dear great people. Is there any Alteryx tool for copying files and posting into a folder in at Alteryx workflow?
Thanks
Hi @Kinetic_analytics you can use the Run Command tool or use a combination of Blob Input and Blob Output tools for this challenge.
@Kinetic_analytics The below posts might be helpful for your use case
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/File-Copying-and-Moving/td-p/592216
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Configure-Run-Command-tool-to-move-a-file/td-p/11139
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Copy-and-Paste-Excel-from-one-folder-to-another-and-add-date/td-p/792702
Thanks. Do you have any example for me to tackle the situation?
You can use python both to MOVE and COPY simply replace copy with move.
from ayx import Alteryx import shutil import os import pandas as pd def archiving(a): source=a['filepath'].tolist() destination=a['destination'].iloc[0] destination=destination.replace('\\','/') source=[shutil.copy(each,destination) for each in source] dicty={"newfiles":[destination+os.path.basename(each) for each in source]} output=pd.DataFrame.from_dict(dicty) Alteryx.write(output,1) df=Alteryx.read("#1") archiving(df)
Here's a related Idea, that could benefit from a few more Likes:
File Management tools (copy, rename, delete)
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/File-Management-tools-copy-rename-delete/idi-p/1870
Thank you @amirsemsar
