select.md

Select - Select, re-order, drop columns

sample file
┌─────┬────────┬─────────────┐
│ idx │ name   │ _filename_  │
├─────┼────────┼─────────────┤
│  1  │ tom    │ test1.csv   │
│  2  │ jerry  │ test1.csv   │
│  3  | hansen | test1.csv   │
└─────┴────────┴─────────────┘

1. Include

Set criteria (Select column: name,idx, Select mode: Include)

┌────────┬─────┐
│ name   │ idx │
├────────┼─────┤
│ tom    │  1  │
│ jerry  │  2  │
│ hansen |  3  |
└────────┴─────┘

2. Exclude

Set criteria (Select column: name,idx, Select mode: Exclude)

┌─────────────┐
│ _filename_  │
├─────────────┤
│ test1.csv   │
│ test1.csv   │
│ test1.csv   │
└─────────────┘