connect two tables with starting word

[ajitrikibe]

Names			Full names	income
AMIT			AMIT das	50000
SANA			AMIT tode	40000
AISH			AMIT faruq	230000
			AISH dole	300000
			AISH wai	500000

 Hello Everyone, I have two tables , 1st table consists of starting name, and 2nd table consists of full name. I want to display chart for all entries present in table 2 if I select data from table 1.

For eg. If I select AMIT from table1 ,then it should select all amit in table 2, and display the income chart

[PattemManohar · Accepted solution]

@ajitrikibe Here is the step you need to do in "Power Query" using "Split Column" option.

Please note - Your data might have middle names as well but still you might need to join only first name (string upto to first space).

Source Input

Split Column

Output

[petrovnikitamai]

try to create new column in table2, for example

shortName = left([Full names];4)

and create link betweem to tables t1[Names](1)->(*)t2[shortName]

[AkhilAshok]

Why don't you try splitting the Full Name column using Power Query Editor?