Filter Data Table - data inside data

Help Studio
, ,
1

Hi There

I’d like to remove “success”, “error”, “sell_pressure” columns from datatable filtering

imagem

I’m doing this:

imagem

the problem is that I don’t know how to select “sell_pressure” wich is inside “data” and “0”.

I’d like to have some support here.

Thanks in advance

2

may we ask you for some more details?

  • How is the JSON converted to the datatable
  • can you share some details / samples form the datatable and its structure

Thanks for support

3

Hi Peter

I’m converting by the simplest way

imagem
imagem542×594 13.2 KB

Nothing “fancy” around here. I think…

Thank you

4

Yes, but we dont know the JSON and cannot check the resulting datatable structure. What we want to check on how the JSON nested structure is mapped to the Datatable column structure

Thats why we asked also for:

5

I thought the structure was in that picture:

imagem

in raw format is like:

{“success”:“true”,“error”:“false”,“data”:[{“trend_score”:49.34,“buy_pressure”:52.61,“sell_pressure”:47.39,“timestamp”:“2022-03-29T10:56:00.000Z”}]}

Thank you once again Peter.

6

Please help us by not let remaining questions open:

this was an enhanced visualization, but not rwa json

data Property has a nested JArray and we need to know the corresponding datacolumn structure.

Otherwise we would create the datatable from JSOn by a LINQ statement

7

As an alternate you can obtain the datatable from the JSON

grafik
grafik730×268 30.5 KB

by:
grafik

and remove the unneded column as you had startet with the filter datatable activity

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.