Forum Discussion

anna-lee's avatar
anna-lee
Icon for Helper I rankHelper I
3 years ago
Solved

Conditional column to apply only on first instance

Hi, I'm having difficultly creating a conditional column to only apply on the first instance and populate "null" afterwards. I have an Index column with no duplicates, but I'm currently still reci...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    You can make a duplicate query, add an index, find the first instance of your value, and then use that index number as the parameter for Table.SplitAt. Then you can transform on your bottom table, and then Union (Table.Combine) your tables back together.

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
3 years ago

You can make a duplicate query, add an index, find the first instance of your value, and then use that index number as the parameter for Table.SplitAt. Then you can transform on your bottom table, and then Union (Table.Combine) your tables back together.

 

--Nate