Forum Discussion

CallumJ's avatar
CallumJ
Frequent Visitor
4 years ago

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...
Need Help
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago

NewStep=let grp=Table.Buffer(Table.Group(PreviousStepName,"Doc ID",{"n",each if List.Contains([Comment],"Identifier") then "Identifier" else null})) in Table.AddColumn(PreviousStepName,"Comment Check",each grp{[#"Doc ID"=[Doc ID]]}?[n]? ??"Fail")

CallumJ's avatar
CallumJ
Frequent Visitor
4 years ago

Hi Daniel,

I was unable to port this step into my editor successfully, not sure how to add this as an additional line in my existing code of 10 or so lines.