Need help in custom column

[sribmc]

I have 2 tables which contains states data.I want to create new custom column at table 2 to show matched values from table1

Table 1	Table 2
Andhrapradesh	Telangana(456)
Telangana	Punjab(45)
Karnataka	Andhrapradesh(67)
Punjab	Sikkim(55)
Sikkim	Karnataka(44)

Expected ouput

Table 2 MSTATE

Telangana

Punjab

Andhrapradesh

Sikkim

Karnataka

[Rupak_bi]

Hi @sribmc ,

Still not very much clear. What I understood from the sample data is, You want to display the state name from table 1 beside the state name in table 2. Here is the solution of that.

this is table 1

This is what I did in table 2
first extracted the text from the sate name column

Then refered the matched state name from table 1

If this is what you are asking , please accept as solution, else please elaborate your ask.

[techies · Accepted solution]

Hi @sribmc please check this

if List.Contains(#"A"[table A], [table b]) then [table b] else null

[Rupak_bi]

Hi @sribmc ,

Your ask is not very much clear. however, to get data from table 1 , create a relationship between two tables on state name, and then you can get desired data from table 1 in table 2.  Else, plz elaborate your ask.

[sribmc]

@Rupak_bi Both the tables are already linked up at backend with state id but we need to show matched values beside each record.

[sribmc]

on custom column each record of state value under table2 need to search all the values in table1 and what ever matched value with pattern then it should show beside the value of table2