In my Json I have some null values in one column.when am using the column as filter in GUI it is showing two blanks.How can i make it show as one blank.
Hello, Kranthi,
Thank you for your question.
Our team would like to kindly inform you that we did not manage to reproduce the described behavior on our side.
Please see an example we have prepared trying to reproduce the issue.
It would be useful for our investigation if you could modify the mentioned example in the way the problem can be seen.
We are looking forward to hearing from you.
Kind regards,
WebDataRocks Team
Hello,
I had the same problem. In my case the first blank is the only first row in my JSON data. No matter which one. I tried to exclude the row from a request and then the second row from JSON data became the first blank.
The problem was solved when I replaced null in the JSON data with the empty string “”.
With best regards,
Vladimir
Attachments:
Hello, Vladimir,
Thank you for sharing your solution on our forum.
Also, your description helped us to reproduce the problem on our side.
We would like to kindly suggest considering using the meta-object in order to avoid such behavior.
Such an object is represented as the first element of an array for JSON or the first row for CSV. One of its tasks is to predefine the set of hierarchies and measures. It allows avoiding automatic detection of hierarchies by the component and eliminates the problem you are facing.
For example, the doubling of the “blank” member can be omitted by adding the meta-object to the data set:
[
{
Color: {
type: "string"
},
Price: {
type: "number"
},
Quantity: {
type: "number"
}
},
{
Color: null,
Price: 4677,
Quantity: 57
},
{
Color: null,
Price: 1222,
Quantity: 730
},
...
}
Please check out an example demonstrating the result with and without using the meta-object by the link.
We hope it works well for you.
Do not hesitate to contact us in case further questions occur.
Best regards,
WebDataRocks Team
Thanks for reply.
Thanks a lot.
It works.