Uploaded image for project: 'CDAP'
  1. CDAP
  2. CDAP-11898

Data prep column names with spaces not parsed correctly

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.2.0
    • Fix Version/s: 4.3.1
    • Component/s: Data Prep
    • Labels:
    • Rank:
      1|hzy1pq:zzzzzzzyzzzzzzzzzzzr9

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              bhooshan Bhooshan Mogal
              Reporter:
              joe.farned Joe Farned
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: