Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
BigQuery supported tables with nested and repeated columns. I tried to import data
from BigQuery into Qlik Sense that with nested and repeated columns and it looked messed up.
Anyone successfully done this? Or perhaps it is known to be not supported?
Thanks,
Chris
What do you mean by repeated columns?
I don't know if the last message went through so I'm repeating it again..... Imagine a CustomerOrder SQL table with multiple instances of a "product" column, one for each product in the ecommerce order. Furthermore, each of the product column values might have nested values like product_quantity, product_price, product_shipping, etc. I tried to pull BigQuery data into Qlik Sense using these BigQuery features and it looks like it got messed up.
Can you please paste query with one filed how it is loading, I have same schema before in Big query and I simply used * to pull the all fields. But want to see how your Rest is capturing and which JSON code is generating when it comes to Qlik?
I don't have an idea on this, I understand your requirement but it is different that what i handled. I am afraid whether you can achieve this. But, let's see if @Vu_Nguyen can help
Anil
You were able to watch the video I made to see what I mean?
cs
Did manage to sort this out with out flattening the nested array? Thanks