One Star

tBigQueryOutput to record field

Hello, 

 

I have a bigQuery table with a record field, (field "city" with "city.id" and "city.name"). How can I populate this field with a tBigQueryOutput ?

 

I tried city_id and city_name in the output scheme but it doesn't work.

 

Thanks in advance, 

 

Sylvain

1 REPLY
Five Stars

Re: tBigQueryOutput to record field

Hello,

 

I would try the Object datatype where you prepare the structure. Have you tried this way?

 

Regards

lojdr