Add Conditional Column to Parquet Files Online
Add a new column to Parquet files based on an if/else condition directly in your browser. Set a value for rows that match and a different value for rows that don't — no upload required.
How to add Conditional Column to Parquet files
- Drop your file onto the upload area. The first 200 rows are shown.
- Build the condition: pick the column in If column, choose an operator such as equals, contains, greater than or is empty / null, and type the compare value.
- Set the Then value for rows that match and the Else value for rows that do not. The defaults are true and false.
- Name the new column (the default is new_column) and click Add Column. A one-line summary of the rule is shown above the button so you can check it.
- Check the preview and download the file. The new column is added at the end.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A help desk promises a first response within 48 hours. The team lead wants a flag on every ticket in this week's export so overdue ones can be filtered and chased.
Input (Parquet)
Parquet file (binary, columnar) — shown as a table with its schema
| ticket_id | priority | hours_open |
|---|---|---|
| 5012 | high | 52.5 |
| 5013 | low | 6 |
| 5014 | medium | 48 |
| 5015 | high | NULL |
| 5016 | low | 120.25 |
Schema: ticket_id BIGINT, priority VARCHAR, hours_open DOUBLE
Settings
- If column: hours_open
- Operator: > greater than
- Value: 48
- Then: overdue
- Else: on track
- New column name: sla_status
Result
| ticket_id | priority | hours_open | sla_status |
|---|---|---|---|
| 5012 | high | 52.5 | overdue |
| 5013 | low | 6 | on track |
| 5014 | medium | 48 | on track |
| 5015 | high | NULL | on track |
| 5016 | low | 120.25 | overdue |
Greater than is strict, so ticket 5014 at exactly 48 hours is on track. Pick greater or equal to include it. Ticket 5015 has no hours recorded. An empty value never passes a comparison, so it falls to the Else value. Add a second run with is empty / null if missing data needs its own label.
Working with Parquet files
Parquet columns have fixed types, and each operator follows them. Numeric columns of any width, INT32, INT64, DECIMAL or DOUBLE, compare as numbers. Date and timestamp columns compare as dates, so greater than 2026-04-11 flags every later date. Type dates as 2026-04-11 or 2026-04-11 09:30:00. A value that is not a valid date stops with a message. Contains and the other text operators work on any column.
The new column is always a string column in the output schema, even when Then and Else are true and false or 1 and 0. Systems that expect a BOOLEAN or INTEGER flag will need a cast. Run Cast Columns on the result if you want a real boolean. Boolean source columns can be tested with equals and the value true or false. Every original column keeps its Parquet type.
Frequently Asked Questions
What type is the new column in the Parquet output?
Always a string (VARCHAR), whatever you type in Then and Else. Use Cast Columns afterwards to turn "true" and "false" into a BOOLEAN column.
Can I flag Parquet rows where a timestamp is after a certain date?
Yes. Pick the timestamp column, choose greater than and type a date such as 2026-04-11. The value is compared as a date, not as text or a number.
Can I add more than one condition, like IF / ELSE IF?
No. Each run applies one condition with one Then and one Else value. For more outcomes, run the tool again on the result, or write a CASE WHEN expression in the SQL workspace.
What happens to empty values in the condition column?
They never pass equals, not equals or a comparison, so they get the Else value. Use the is empty / null operator to target them directly.
What if I type text as the value for greater than?
On a number column the tool stops and asks for a number. A value such as "48h" or "1,200" is not accepted. Enter digits only, with a dot for decimals. On a date column, type a date such as 2026-04-11.
Related Tools
Filter Parquet Files Online
Filter rows in Parquet files by column value, directly in your browser. Your data stays on your device.
Count Values in Parquet Files Online
Group and count rows by any column in Parquet files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.
Cast Column Types in Parquet Files Online
Change column data types in Parquet files directly in your browser. Cast text to numbers, dates to timestamps, or any supported type conversion — no upload required.
Add Conditional Column to CSV Files Online
Add a new column to CSV files based on an if/else condition directly in your browser. Set a value for rows that match and a different value for rows that don't — no upload required.
Add Conditional Column to Excel Files Online
Add a new column to Excel files based on an if/else condition directly in your browser. Set a value for rows that match and a different value for rows that don't — no upload required.
Add Conditional Column to JSON Files Online
Add a new column to JSON files based on an if/else condition directly in your browser. Set a value for rows that match and a different value for rows that don't — no upload required.
Parquet Viewer Online
View and inspect Parquet files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Parquet to CSV Online
Convert Parquet files to CSV format directly in your browser. No upload required — your data never leaves your device.