Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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.

Avatar

Level 2

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%2FRe...

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

5 Replies

Avatar

Community Advisor

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)

Avatar

Level 2

That worked! I was missing adding the column number. Thank you so much!

Avatar

Community Advisor

you're welcome! I went ahead and notified the help article people to rewrite their article to be less ambiguous so it doesn't catch the next user unawares!

Avatar

Level 10

There is a video and text tutorial available on the wonderful and informative WF-Pro.