File Copy and Move tool

[Kinetic_analytics]

Hello:

Dear great people. Is there any Alteryx tool for copying files and posting into a folder in at Alteryx workflow?

Thanks

[JosephSerpis · Accepted solution]

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]

Thanks. Do you have any example for me to tackle the situation?

[binuacs · Accepted solution]

@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-f...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Copy-and-Paste-Excel-from-one-folder-t...

[amirsemsar]

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)

[ChrisTX]

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...

[Kinetic_analytics]

Thank you @amirsemsar