How to add folder name to every rows after importing multiple files to the workflow?

[acaryasin01]

Hi guys,

I have 3 folder all included csv file (Folder A – Folder B – Folder C)

Each folder have many files, each files belongs a specific company and many rows in its file

There is no relation and no included folder info between csv file name (also inside the file info) and folder name.

For example Folder name AEX but files name xyz co. so on so forth.

But my question is to determine which row belongs to which folder (not the file) after importing all files to the workflow.

I can do this by importing 3 separate input tools and then adding 3 formula tools to add its file name as a new column. (See attached my screen shot)

But if possible I would like to have these in a one input tool and one formula tool or something like that.

Anyone can help me?

[atcodedog05 · Accepted solution]

Hi @acaryasin01 

You can configure input tool to output full path refer to highlighted config. This way you will be able to get to know the folder.

Hope this helps : )