I'm blending two sources on a key which is fine and while adding fields from secondary source on to rows it worked fine until i added 2 fields..but after 3 field onto row...I see something weird behavior.. It is causing the first two fields in the rows to merge automatically separated by a comma. Not sure why it is happening. If i remove any one of the field from the rows then again the first two fields in the rows shelf which were merged are splitting again back to normal. Not sure why is that.
Please let me know your thoughts/suggestions.
This is because you have reached the maximum column count
You can increase this to 16
menubar on top ---- Analysis> Table Layout > Advanced