Loading

Broadcasting in multi-dataset queries with coalesced fields from different datasets

Дата публикации: Apr 30, 2026
Описание

In a query involving multiple datasets, when creating coalesced fields that combine fields from various datasets—whether through direct reference or dynamic references using interaction syntax from another query—broadcasting may not occur if the coalesced projected field name does not match an API field name from the first loaded dataset.

Решение

For example, if you create a coalesced field using the foreach generate syntax, the output field alias should match an API field from the first dataset in the query to allow broadcasting to function correctly.

E.g: q = foreach q generate coalesce(q1.'ds1.customFieldA', q2.'ds2.customFieldA') as 'ds1.customFieldA', etc...

Дополнительные ресурсы

Related Help Content:

Facet Queries with Multiple Datasets

Номер статьи базы знаний

002471442

 
Загрузка
Salesforce Help | Article