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: ReferenceDisclosureSectionCurrent ResponseA1.1.1The name of company or fundGeneralYesCommentSee financial statement A1.1.2A description of each statementGeneralYesCommentSee basis of presentation Ideally, the output would be structured as: ReferenceDisclosureSectionCurrent ResponseCommentA1.1.1The name of company or fundGeneralYesSee financial statementA1.1.2A description of each statementGeneralYesSee 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

Appending Row to Related Reference in Column

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

Help

Accepted answers

mceleavey

Sorry, wrong version.

New one attached.

Checklist Workflow_mceleavey.yxmd

All comments

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,

mceleavey_solution.yxmd

Kristopher_Siple

Also meant to upload the current workflow & input file

Checklist Workflow.yxmd

Q4 2021 Disclosure Checklist.xlsx

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703