Forum Discussion
Creating a table from 2 other tables
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 |
3 Replies
macgeorge , Try with generate
generate('Table1'[Full Name], filter(Full Name, 'Table2'[DISPLAY_NAME] = upper('Table1'[Full Name])))
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 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.
