Creating a table from 2 other tables

[macgeorge]

I am trying to create a 3rd table (table c) that will present all names has a "Full Name" column from table a, and will list all the names under "DISPLAY_NAME" from table b, and the LICENSE_NO column also from table b.

The license number should only be entered into table c if there is a match of the full name (from table a and b) if there is no match then a null value is entered into the License_No column in table c.

I have example tables below and I would be grateful for any help in this please.

I was using a crossjoin (below) but this did not work the way I wanted. 

Table = CROSSJOIN(DISTINCT('Table1'[Contact ID]),DISTINCT('Table2'[BC #])

table a

Full Name

Aaron

Ryan

Adam

Peter

John

Kevin

David

Adrian

Alex

Bryan

Allan

Sarah

Clare

table b

DISPLAY_NAME	LICENCE_NO
AARON	1301
ADAM	1305
PETER	1309
JOHN	1313
DAVID	1317
ADRIAN	1321
ALEX	1325
ALLAN	1329
SARAH	1333
CLARE	1337

table c (example of how I would like it to look like)

Full Name	License_No
Aaron	1301
Ryan
Peter	1309

[macgeorge]

I am still struggling with this. I have tried the generate and although I followed your suggestion (and reviewed the youtube you advised), it didnt work for me. It was coming up with syntax errors on my table. I will keep trying.

[macgeorge]

thank you. i did check this video out, but is doesnt give me what i want, which is the following: 

table c

Full Name	License_No
Aaron	1301
Ryan	null
Adam	1305
Peter	1309
John	1313
Kevin	null
David	1317
Adrian	1321
Alex	1325
Bryan	null
Allan	1329
Sarah	1333
Clare	1337

[amitchandak]

@macgeorge , Try with generate

generate('Table1'[Full Name], filter(Full Name, 'Table2'[DISPLAY_NAME] = upper('Table1'[Full Name])))

https://www.youtube.com/watch?v=QRWBfMujaXw