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.