Get values from columns in table A and concatenate in column in table B

[Dicko]

Hi all,

Newbie here, just learning as I go.

I have two tables (just a simplified example):

DETAILS

detail_id

firstname

lastname

GENERAL

general_id

detail_id

name

I want GENERAL[name] to be a concatenation of DETAILS[firstname] and DETAILS[lastname].

How do I go about that.

Thanks.

[amitchandak · Accepted solution]

@Dicko , a new column in GENERAL table

maxx(filter(DETAILS, DETAILS[detail_id] = GENERAL[general_id]) , [firstname] &" " & [lastname])

or

concatenatex(filter(DETAILS, DETAILS[detail_id] = GENERAL[general_id]) , [firstname] &" " & [lastname] ,", ")