Does anyone know how to merge data from multiple columns into one? I was able to merge 2 but I cannot merge more than that.

Question

I followed the directions in the link below and it worked for two columns but I cannot figure out how to merge more than two columns (include the previously merged column). I am trying to pull the data from multiple fields into one column in my Project List. If this can be done without merging columns, I would love to explore that option as well.

Any help would be appreciated!

https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FCustom_View_Filter_Grouping_Samples%2Fview-merge-columns.htm&_LANG=en

skyehansen · Answer

Just keep doing the same thing! The new column you want to merge (the mergee) should always be to the right hand side of the thing it's merging into (the... merger??). Edit the merger, and add sharecol=true to the bottom AND its column number (the final line in the merger should give you a clue as to what number to use).

e.g. your new line might look like this: column.4.sharecol=true

Pray you don't accidentally merge something out of order, as it's a bit of a pain to separate a merged column. (basically involves finding the correct sharecol=true line to delete)

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded