Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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.