Forum Discussion

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
5 years ago

CONCATENATEX unique value

Hi   I have a two tables are Data and Report, both tables contain the same headers are “Item” and “Comments”.   DATA   In data table the item columns contains prefix only and the same item cont...
Need Help
Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
5 years ago

I created helper column for item in report table (Keep only prefix-item1) and I apply the following calulated column 

CONCATENATEX(FILTER(ALL(DATA),DATA[ITEM]=EARLIER(REPORT[ITEM1])),DATA[COMMENTS]),"||") but it will bring it duplicated comments.
 
I would like to achieve my desired result without duplication columns.
 
Any advise please.