Forum Discussion

manutremo's avatar
manutremo
Frequent Visitor
5 years ago
Solved

Stack overflow error when deleting structured column without expanding it first

I'm merging two tables using Left anti join as part of the processing of a dataflow. The purpose of this merge is just deleting some rows in the main table based on the content of the other table. Th...
  • edhans's avatar
    5 years ago

    There are several oddities with deleting a column created from a nested join. It also breaks folding.

    Rather than an anti-join, consider using a simple filter that uses List.Contains() - or in your case - not List.Contains(). This article will walk you through the equivalent of an inner join without creating unnecessary columns. By putting "not" in front of List.Contains, it will become an anti-join.

    Using List.Contains To Filter Dimension Tables — ehansalytics