When I import the attached CSV file into Data Prep and parse as a CSV, I cannot filter the data properly. For instance, if I filter on the "State" column equaling "CA," no rows are returned, although several should be.
This is because in the CSV file there is a space in front of the column name " State." When the space is removed, filtering works correctly.
The column name is displayed as "State" in the UI – so the space is not parsed correctly elsewhere.