Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Use Run Command tool to call outside application to decrypt a PGP file

Highlighted
Alteryx Partner

Hello,

 

Here's what I'm trying to do:

 

  1. Use a Text Input tool to move an encrypted PGP file from an FTP site to local machine. (I figured this part out)
  2. Use the Run Command tool to call an outside application to decrypt the PGP file and save it to local machine.

The problem I'm having is the Run Command tool will not recognize the PGP file. I'm not asking Alteryx to do anything with the PGP file; I only want it to recognize the file in the Run Command tool so I can point the outside application to it and decrypt it. 

 

Can anyone help me with this?

 

Thank you!

Highlighted
Alteryx
Alteryx

@pmarzano have you tried bringing the file as a .csv with \0 delimiter? Alteryx is not going to be able to read the encrypted file, but you can use the run command tool to create a script. Are you able to share a sample workflow as well?

Digan
Alteryx
Highlighted
Alteryx Partner

@DiganP That worked! I'm not sure why it worked, though. Can you explain a little further if you have a moment?

 

Thank you! This just made my life a lot less stressful. 

Highlighted
Alteryx
Alteryx

@pmarzano By default, the input tool is going to try to parse the dataset based on a delimiter or the file type. Usually, this is a tab (\t), comma (,) or space (\s). For some files, this is not going to work (PGP file in this instance). So if you just bring in the file (any file) as a .csv with \0 delimiter it will bring the 'raw' format. Hope this helps

Digan
Alteryx
Highlighted
Alteryx Partner

I truly appreciate all of your help. Thanks again!

Highlighted
5 - Atom

hi @pmarzano 

 

We have a similar requirement of decrypting a PGP file and import the data in DB.

 

Any help to achieve this would be highly appreciated.

 

Thanks

Jatin 

 

Labels