Rational Test

 View Only
Expand all | Collapse all

dataset "Missing column

  • 1.  dataset "Missing column

    Posted Wed March 31, 2021 03:48 AM

    When attempting to use a dataset mapper or a variable assignment to populate a variable using a dataset, if there is no value in the field its actually assigning the text "Missing column <columnName>" instead of a blank or empty value.

    How can I get rational performance tester to assign a blank or empty value to the test variable instead of "Missing column <columnName>"


  • 2.  RE: dataset "Missing column
    Best Answer

    Posted Wed March 31, 2021 04:02 PM

    Hi, I was able to reproduce this issue on 10.1.2, what version are you using?

    I reported this to my dev team and they'll investigate this as a defect to be fixed in a later release.

    In 10.1.2 the workaround that worked for me was:

    1. replace all null values in the dataset with the string "empty" (no quotes)
    2. edit the dataset in the dataset editor
    3. on upper left corner of the dataset editor click on the last icon, the one with 3 dots
    4. choose Configure
    5. There's two options under "String Settings"
    • Treat as Null
    • Treat as empty

    6 under Treat as empty put in the string "empty" (no quotes)

    7 Update

    8 save the dataset and rerun the test


  • 3.  RE: dataset "Missing column
    Best Answer

    Posted Thu April 01, 2021 02:10 AM

    I'm using version 10.1.2 Test work around and it was successful, thanks for your help.