Combine Files: Want to include another column as repeated

Question

HiWhen I click on the two down arrows to combine, I get the expanded Content.&nbsp;Which is good, but the Source.Name column disappears, leaving just the expanded content with its rows A,B,C &amp; D.&nbsp;A&nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Bill&nbsp; &nbsp;Rodgers&nbsp; &nbsp;23/11/22&nbsp; &nbsp; &nbsp; 500&nbsp;Jo&nbsp; &nbsp; &nbsp;Hind&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;23/11/22&nbsp; &nbsp; &nbsp; 401&nbsp; &nbsp; &nbsp; &nbsp;Jill&nbsp; &nbsp; &nbsp;Hind&nbsp; &nbsp; &nbsp; &nbsp; 11/10/22&nbsp; &nbsp; &nbsp; 431&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; Bind&nbsp; &nbsp; &nbsp; &nbsp;11/11/21&nbsp; &nbsp; &nbsp; 222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Jo&nbsp; &nbsp; &nbsp; Kind&nbsp; &nbsp; &nbsp; &nbsp; 11/12/21&nbsp; &nbsp; &nbsp; 223&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;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&nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Source.NameBill&nbsp; &nbsp;Rodgers&nbsp; &nbsp;23/11/22&nbsp; &nbsp; &nbsp; 500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;firstJo&nbsp; &nbsp; &nbsp;Hind&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;23/11/22&nbsp; &nbsp; &nbsp; 401&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;first&nbsp;Jill&nbsp; &nbsp; &nbsp;Hind&nbsp; &nbsp; &nbsp; &nbsp; 11/10/22&nbsp; &nbsp; &nbsp; 431&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;secondJan&nbsp; &nbsp; Bind&nbsp; &nbsp; &nbsp; &nbsp;11/11/21&nbsp; &nbsp; &nbsp; 222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;secondJo&nbsp; &nbsp; &nbsp; Kind&nbsp; &nbsp; &nbsp; &nbsp; 11/12/21&nbsp; &nbsp; &nbsp; 223&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;second&nbsp;How can that be done?Many thanks for looking 🙂&nbsp;&nbsp;

imkef · Accepted Answer

Hello&nbsp;laganlee&nbsp;,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:

&nbsp;

Forum Discussion

Combine Files: Want to include another column as repeated

2 Replies

Related content

Tables combine

Paginated Report headers not repeating

Data Combining Problem

Combine Column

Dynamic RLS combination