Appending Row to Related Reference in Column

[Kristopher_Siple]

Hi There,

A bit inexperienced with the Append tool and am attempting to create a new column which has the associated comment in the same row. The data as it currently structured is:

Reference	Disclosure	Section	Current Response
A1.1.1	The name of company or fund	General	Yes
Comment	See financial statement
A1.1.2	A description of each statement	General	Yes
Comment	See basis of presentation

Ideally, the output would be structured as:

Reference	Disclosure	Section	Current Response	Comment
A1.1.1	The name of company or fund	General	Yes	See financial statement
A1.1.2	A description of each statement	General	Yes	See basis of presentation

My workflow is currently filtering out the rows which contain "Comment", but I am having an issue appending it to the related Reference row. Any insight is greatly appreciated!

Thank You,

Kris Witha

[mceleavey]

Hi @Kristopher_Siple ,

assuming your data is representative of the live data, the following will work:

This splits out the comment rows and joins them back on record position.

Hope this helps,

M.

[Kristopher_Siple]

Also meant to upload the current workflow & input file

[Kristopher_Siple]

Thanks for the recommendation @mceleavey

I provided a poor example of the data as not every row is in a similar format with a comment directly following each. I have a similar setup to your recommendation, but the data isn't as clean as my initial post represents

I uploaded the full data set to provide additional detail.

[mceleavey]

@Kristopher_Siple ,

try the attached.

I changed the ending but used a similar approach.

M.

[mceleavey · Accepted solution]

Sorry, wrong version.

New one attached.

[Kristopher_Siple]

That looks great, @mceleavey (not sure I can directly mention due to my ranking).

Greatly appreciate the help! Have an awesome day.

Kris

[mceleavey]