I’m working with a folder structure like this:
IMS
└── FY25
├── Jan
├── Feb
├── Mar
├── Apr
├── May
├── Jun
├── Jul ← this month (should auto-select)
└── Aug ← next month (should auto-select next month)
```Each month folder contains ~7 different Excel files, each with different sheet names and varying data layouts.what I Want to Achieve:
1. **Auto-select the current month’s folder**
→ e.g., In July → read from `IMS\FY25\Jul\`
→ In August → read from `IMS\FY25\Aug\`
→ *No manual path updates needed month-to-month*
2. **For one specific Excel file in that folder**, I need to:
- Read **only visible cells** (i.e., skip hidden rows/columns)
- Read range starting from **A1 to row 40**, but **dynamically extend to the last used column**
→ e.g., This month: A1:F40 → Next month: A1:G40 → etc.
→ Column count increases monthly, so I can’t hardcode it.
My Questions:
- How do I configure **Directory Tool + Dynamic Input** to auto-navigate to the **current month’s folder** based on system date?
- How can I make the **input range dynamic** to capture **A1 to Row 40 + Last Column** without hardcoding?
- Is there a way to ensure **only visible cells** are imported? (Alteryx doesn’t natively skip hidden Excel cells — any workaround?)
