Invisible fields in analysis

Q&A
,
1

Hi everyone,

I wrote a query that extracts some JSON fields in a specific table and transforms them to a visible format in Quicksight.
When I conduct an analysis on that dataset alone (that query is a standalone dataset) then I get values (hence the field itself and hence what it contains).
However, when I join that table to another one and create a larger dataset, these fields do exist. Like the machine in unable to recognize them. The weird thing is that it happen only with specific fields. With other fields that I transformed, Quicksight does recognize.
Has anyone ever encountered such a problem?

Thanks,
Etai

2

Hi @Etai
can you show a sample?
What kind of join are you using?
BR

3

Hi @ErikG ,

Thanks but I was able to solve it.
I created an initial data set and then created another one with a query referring only to that JSON field from that table. So essentially I joined the table to itself. What may have caused the problem.
I then created a new query with all the fields and a transformation field for the JSON so it would be in one place. It worked…
Thanks again,

Etai

2 Likes