Updating a value without using the action tool

Question

Hello,

I am currently building a macro to allow users to upload to hdfs. I have a tree tool which allows the user to select the filepath of where they would like to save to, which spits out the key to the action tool in my workflow. I am using this action tool to filter a table down to the row which includes the filepath. At this stage, I'd like to replace the filepath in the output tool I'm using with the value from the "true" part of my filter.

The effect I'm looking for is identical to what the action tool would do (Update Value (default) to replace "folder/subfolder" in my connection string with the value from the filter) but I can't use the action tool as the input isn't coming from an interface tool.

Any help would be much appreciated.

(In red below is essentially what I want to do)

SamDesk · Accepted Answer

Hello @JonnyR,

If you append the "folder/subfolder" field to the "mapping csv" input, you could then pass that field to the Output tool to replace the output path.

If you're able to share your workflow file I'd be happy to set up a demo of what I mean.

Sam :)

SamDesk · Accepted Answer

Hi @JonnyR,

Yes, it keeps them all in the same file, it sort of does a group-by pre-export on the file path and then outputs all records with that file path together in the same file.

Sam :)