How do I want to map with Table 1 and 2

[Chinnu3]

Hi All,

I want to map the 2 tables

In result i want to see this

Thanks in advance.

[Bhuvi · Accepted solution]

SubField(Full Name,' ',1) as Name

Give one space between the quotes

Its working for me