Alteryx - Run Command Like a Boss

แชร์
ฝัง
  • เผยแพร่เมื่อ 12 ต.ค. 2021
  • Have an app or program that you want to do some work outside of Alteryx? You can use the Run Command tool to execute a process.
    Big thanks to Lucia for suggesting the topic!
    You can watch the related video about using the Email tool here: • How to Use the Alteryx...
    Contents
    01:19 Intro
    01:53 Run Tool Overview
    03:30 Block Until Done Tool
    06:00 Batch File
    06:58 7-zip Command Line
    07:43 Run External Progam
    09:06 Email Tool Overview
    #NPT #Alteryx #Run #Command
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 16

  • @ahmedsaleh2905
    @ahmedsaleh2905 2 ปีที่แล้ว

    Was wondering if you can show how to trigger a vba code once you outputted a file the online resources weren't very useful

  • @angeleyes9171
    @angeleyes9171 ปีที่แล้ว

    Just getting back to Alteryx after a 2 year hiatus. Trying to read multiple csv files and then move them all into another folder and/or archive. Leaving the existing original location empty for future file drops. I have downloaded 7 zip .. but missing an element for multiple files

  • @MANOSHPROTIMMAJUMDER
    @MANOSHPROTIMMAJUMDER 2 ปีที่แล้ว

    Hi Nathan. I am struggling to use Macros embedded in excel files inside Alteryx. I have some macros enabled excel files and instead running the macros on excel I want to run them on excel. Can you please guide me how to it??

  • @Laxmanmane007
    @Laxmanmane007 ปีที่แล้ว

    please upload video on batch macro I am clear with standard macro but little confuse about batch macro.

  • @karangupta3642
    @karangupta3642 ปีที่แล้ว

    Can you share a video explaining how to unzip a file as a part of the workflow and use selective files from it?

  • @sabuthomas891
    @sabuthomas891 2 ปีที่แล้ว

    Please create a video to justify the test coming out of report text tool...that align feature is missing in report text tool
    There are many who are waiting for this feature..if we can fix with a batch file wud be great

  • @shandor2522
    @shandor2522 2 ปีที่แล้ว +1

    Nathan: Good tips, thanks! But Alteryx really needs to offer a tool to replace that ridiculous 7-Zip thingy that makes users code like the old days!
    Alteryx could make a prompt-driven tool to do the same but with low-code, no-code methods. This will save Alteryxians time & effort during our daily work. Unless email's going out of style in the next year or so.

    • @NPT
      @NPT  2 ปีที่แล้ว +1

      I totally agree, Shandor! I love the term "Alteryxians." I think I'll borrow that term. Yes, there are a few common task that could be built into a few more simple tools, and this is one of them.

  • @MdImran-ug5yj
    @MdImran-ug5yj 2 ปีที่แล้ว

    Can you pls create video for Using bat file

  • @AshokKumar-eu4dd
    @AshokKumar-eu4dd 2 ปีที่แล้ว

    I am big follower of your videos and learned detailed abouts each tools. I would like to ask create a video for multiple file open from floder and create summer and populated that summer in email body and attached respect email and sent to audiences as for condition. Could you please make video .thank you for videos

  • @saleempashashaik7402
    @saleempashashaik7402 2 ปีที่แล้ว +1

    Please create video on Batch file, Thank you for Amazing video

    • @NPT
      @NPT  2 ปีที่แล้ว

      Thanks Saleempasha, will do 👍

    • @neelimakammila7891
      @neelimakammila7891 2 ปีที่แล้ว

      @@NPT waiting for the Batch file video !!

  • @Hinkakan
    @Hinkakan 2 ปีที่แล้ว

    As with so many Alteryx tool, this becomes useless when working with a Server setup for automation, because you would then have to upload the .bat file to the server for this to work.
    Is there no way to execute command-line statements INSIDE the Alteryx flow?

    • @NPT
      @NPT  2 ปีที่แล้ว +1

      That's correct. For a server/gallery workflow, the .bat would need to be located on the server where the workflow is being run. Also, remember to use UNC paths for server workflows.

    • @thulasirao9139
      @thulasirao9139 ปีที่แล้ว

      When you copy the template excel file we can use this batch file. Especially for the pivot table, it helps a lot. The format will not change. Do you have any other option for pivot+ format in the template?