Here are a list of nodes that often used on BIM projects.

• Arithmetic: calculate numerical columns
• Append: affix rows together. Might pair with Coalesce when needed.
• Breakout: extracts a set of columns
• Coalesce: merge columns picking the first non-null value. Often uses to merge data scattered in different columns into one column
• Concatenate: combines 2 or more columns or entire tables
• Diff: find differences between two datasets. Often use to compare data from different model versions
• Dropdown: often pairs with Unique and Filter nodes
• Edit Column: edit the type and name of columns
• Field Calculator: calculates column based on other columns
• Filter: filters inputs based on values in a column. Often pairs with Dropdown to provide interaction on App.
• Group by: often pairs with Summarize, Field Calculator
• Join: combine columns and tables by joining them
• Summarize: often pairs with Group by