ColumnsByAlphaName / Select Layer
Select columns based on alphabetical name matching. Similar to pandas loc[] with alphabetical patterns or dplyr's select() with alphabetical criteria. This operation filters columns while maintaining their original order.
Common applications:
- Extracting related fields (e.g., all customer_* columns)
- Data export with specific column patterns
- Feature selection in machine learning
- Schema validation and verification
- Targeted data analysis
Table
0
0
Table
AsciiOnly
boolControls character matching behavior:
false(default): Matches full Unicode characters (e.g., état, méxico)true: Matches ASCII characters only
Use cases:
false: International datasets, multilingual column namestrue: Standard English naming conventions, legacy system compatibility
IgnoreSpace
boolDetermines space handling in pattern matching:
false(default): Treats spaces as distinct characters (first_name ≠ first name)true: Ignores spaces in matching (first_name = first name)
Important for:
- Flexible column name matching
- Handling inconsistent naming conventions
- Cross-system data integration