Combine Files: Want to include another column as repeated

[laganlee]

Hi

When I click on the two down arrows to combine, I get the expanded Content.

Which is good, but the Source.Name column disappears, leaving just the expanded content with its rows A,B,C & D.

A      B               C                   D            

Bill   Rodgers   23/11/22      500 

Jo     Hind        23/11/22      401       

Jill     Hind        11/10/22      431         

Jan    Bind       11/11/21      222          

Jo      Kind        11/12/21      223             

What I need it to have the Source.Name for each 'Binary' row, i.e. so I can identify the source for each row.

i.e.

A      B               C                   D            Source.Name

Bill   Rodgers   23/11/22      500              first

Jo     Hind        23/11/22      401              first 

Jill     Hind        11/10/22      431             second

Jan    Bind       11/11/21      222              second

Jo      Kind        11/12/21      223             second

How can that be done?

Many thanks for looking 🙂

[laganlee]

Thanks a lot ImkeF!

That is so simple - much appreciated.

[ImkeF · Accepted solution]

Hello @laganlee ,
one of the automatically created steps removes this column. I you click on the gearwheel, a dialogue will open that allows you to check all the columns you want to keep: