HI @CU18040549-0
Parses the entire data table, not just the filtered column ([EOH U] in this case).
If any column (like Size) contains inconsistent or incompatible data types, PAD may fail to process the data table even if the column isn't used in the filter.
This is a known behavior in PAD when working with data tables imported from Excel or other sources, especially when:
Columns contain mixed data types
Option 1: Clean the 'Size' Column Before Filtering
Use “For Each” row loop before filtering:
Loop through each row in %ExcelData%
Use conditionals to check and sanitize the Size column:
Convert to string or number uniformly
Or replace non-numeric values with a default value (0, "", etc.)
Option 2: Remove the Problem Column Temporarily
If the Size column is not needed:
Use "Remove Data Table Column" action before filtering.
Remove Size column from %ExcelData% → create new table
Apply the filter on the cleaned-up table.
Option 3: Ensure Data Consistency in Excel
Open the source Excel file
Make sure the Size column contains only one data type (e.g., convert everything to text or decimal)
Save and reload into PAD
Option 4: Use “Read from Excel Worksheet” with Data Formatting
When reading Excel:
Choose “Preserve format” as False
This sometimes helps PAD infer correct type
Hope this helps,
Usha Jyothi.
