Forum Discussion

CHARLEA1's avatar
CHARLEA1
Frequent Visitor
4 years ago
Solved

Unmerging dataset

Hi there,  I have data that is strangely structured like the following: ColumnA   ColumnB A                 B B                 C and I want to find a way to conver the data to the following...
Need Help
  • CHARLEA1's avatar
    CHARLEA1
    4 years ago

    Following up with this thread that I have solved my issue via merging my table with the same table referencing column B as column A

Anonymous's avatar
Anonymous
Not applicable
4 years ago

= Table.AddColumn(PriorStepOrTableName, "Column C", each if List.Contains(PriorStepOrTableName[Column B], [Column A]) then [Column B] else null))

 

--Nate