Many to one text merge
Hi,
In my FP&A model end-users can add comments(in text format) to a variance module that is dimensioned by the user list(among other dimensions).
How can I consolidate the comments so we can see comments from all users combined? I'm thinking we would have a secondary module not dimensioned by end user.
The main challenge is consolidating the text based comments from many to one.
Best Answer
-
Hi,
I built a similar functionality in one of our models, using TEXTLIST() function.
Please see the screenprint below. You may find the attached link useful.
1
Answers
-
@michael.chefer - When you say consolidate, you mean putting all the comments from all the users into a single item?
0 -
Correct. Have any ideas? I haven't found any community posts that provide a solution.
0 -
@shubhamrawat - Just curious to know will there be any limit of comment items using textlist function? Like it can take how many comments separated by commas?
0 -
@PulkitChawla Function has a limit of 10k Characters, however, it works well in my scenario, as we have short comments only from 10 executives.
0
