DevOps Automation

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>"

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

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