Hey!
We truly hope that our free tool comes in handy for your business, especially these days. Follow our news, stay safe & pivot on!

two blanks

Answered

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.

Attachments:
two blanks.png

5 answers

WebDataRocks Team WebDataRocks April 20, 2020

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

Vladimir April 29, 2020

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:

Attachments:
problem.jpg
solved.jpg

WebDataRocks Team WebDataRocks May 11, 2020

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

Kranthi May 11, 2020

Thanks for reply.

Vladimir May 28, 2020

Thanks a lot.
It works.
 

Please login or Register to Submit Answer