Canvas joining data from two different index/data view into one to show in dropdown

[aman_kumar4 (aman kumar)]

I want to join fields from two indexes/data views into one to show them in canvas dropdown, or want essql version of below sql code

SELECT "client_id" AS id

FROM "client_data*"

UNION

SELECT "identifient_id" AS id

FROM "id_data*"

[Alex_Salgado-Elastic (Alex Salgado)]

Hi @aman_kumar4 ,

ES|QL doesn't have a specific UNION command, so I asked internally, and they suggested trying something roughly like this:

from client_data*,id_data* | eval id = case(client_id IS NULL, identifient_id, client_id) | drop identifient_id, client_id