Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED

Is it possible to derive a column value from the name of the directory a file was loaded from?

I want to be able top drop unmodified user account files (/etc/passwd and /etc/group) into a directory with the name of the host they came from. The output file should include that host name. The objective is to end up with a bunch of user data associated with each host.

3 REPLIES 3
Wei_Tri
Alteryx Alumni (Retired)

This is coming in the next release of the product. (5.1, which is targeted for September).

?

Wei?

?

?

Thanks again, Wei.

TrifactaUsers
10 - Fireball

Alternate approach..

 

one of the alternate is,

  1. In your recipe, add a new column "src_filename" and code it to "CHANGE-FILENAME".
  2. If your job is executing through a framework, then we can read the source file name and replace the text "CHANGE_FILENAME" with real source filename in "script.cli".
  3. In short, before the job execution, replace the value "CHANGE_FILENAME" in your "script.cli" with the real source filename through any scripting and then execute your job.

thanks.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!