Solved: Adding file name as column later in workflow

Question

Hi,

I would like to add a column with the file name from a particular input earlier in my workflow to this (see screenshot attached). Is this possible?

Thanks!

Screenshot 2020-10-20 091208.png

Qiu · Accepted Answer

@furlonla 
Just to add to the solution to @Emil_Kos , after getting file information, an Append Field tool can joint the information together.

Emil_Kos · Accepted Answer

Hi @Qiu,

Good point.

I wonder @furlonla why you wanted to add this later in the workflow? It isn't acceptable for you to add it at the beginning?

EDIT: In this case, @Qiu appending solution should work for you @furlonla

furlonla · Accepted Answer

Hey @Emil_Kos @Qiu

The append fields is creating duplicates, when I add it to the tool before the union tool. When I add it to the original input I'm receiving an error that there are more than 16, there are more than 16 records in the source.

Emil_Kos · Accepted Answer

Hi @furlonla,

If you will use summarize to have only file name(1 column and 1 row) you will be able to use append fields without creating duplicates.

furlonla · Accepted Answer

Thanks a mill - that worked! I summarised by the file name then filtered out the null results and the used the append tool!

Qiu · Accepted Answer

@furlonla 
Select Allow All Appends can resolve that issue of Append Tool.
Appreciate you could mark it as acceped if it works for you.