Forum Discussion
CallumJ
4 years agoFrequent Visitor
Multiple values against a single ID, how to create a column that checks and records.
I feel as though this is definitely answered elsewhere but I cannot find the words to search for it. Basically I have the table below: Doc ID Comment 111 Test 112 Test 111 Iden...
CallumJ
4 years agoFrequent Visitor
Hi Team,
Unsure if I have given enough information. I have about 15000 lines, in that there are maybe 5500 unique Document ID's. For these they may or may not contain the Identifier in the Comment Column. I already have a large amount of code to get the data to a useable state, so I need something that I can ideally plug in at the end. Worst case scenario I can duplicate the data source and then do a merge on the Document ID.