{"id":24483,"date":"2024-03-19T15:14:42","date_gmt":"2024-03-19T14:14:42","guid":{"rendered":"https:\/\/developers.ila.cegid.com\/vision\/\/"},"modified":"2025-10-16T10:38:34","modified_gmt":"2025-10-16T09:38:34","slug":"merge-block","status":"publish","type":"vision","link":"https:\/\/developers.ila.cegid.com\/en\/vision\/documentation\/consultations\/article\/merge-block","title":{"rendered":"Merge Block"},"content":{"rendered":"

The Merge<\/strong> block of a Vision query allows to incorporate information from 2 different data sources in the same widget. It is a stage of the query equivalent to a lookup operation (excel, NoSQL) and partly to a join in SQL.<\/p>\n

A Vision query proceeds as a succession of individual query blocks, in a main pipe. The merge block allows the establishment of a second auxiliary row, with its own associated data source or dataset, so that the output of this row is combined with the main row at the corresponding query stage. The type of combination of both lines is indicated by the user, establishing the relevant equivalences or association rules between both lines.<\/p>\n<\/div><\/section>\n

Example<\/h2>\n

A typical example helps to understand in a simple way what a merge block does:<\/p>\n

\"\"<\/p>\n<\/div><\/section>\n

    \n
  1. A query has as its main line data from dataset A, which includes the customer ID and associated sales. The customer ID is a useful field for efficient storage of information, but it does not provide information to a user viewing data. It is normal to want to decode that ID.<\/li>\n
  2. A second dataset B has the equivalences between customer ID and its associated sales agent. A secondary query is defined with data source dataset B, and that combines with the main line by the customer ID field. Therefore, for each customer ID in the main line, its agent is searched for using the secondary line.<\/li>\n
  3. The result of the merge block will therefore be 3 fields: the customer ID and the associated sales, which come from the main line, and the sales agent, which come from the sub-line.<\/li>\n<\/ol>\n<\/div><\/section>\n