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 1Table 2AndhrapradeshTelangana(456)TelanganaPunjab(45)KarnatakaAndhrapradesh(67)PunjabSikkim(55)SikkimKarnataka(44) Expected ouputTable 2 MSTATETelanganaPunjabAndhrapradeshSikkimKarnataka

Hi sribmc please check thisif List.Contains(#"A"[table A], [table b]) then [table b] else null

Need help in custom column | Microsoft Fabric Community

Rupak_bi
Super User
1 year ago
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
  Helper I
  1 year ago
  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
    Helper I
    1 year ago
    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
techies
Super User
1 year ago
Hi sribmc please check this
if List.Contains(#"A"[table A], [table b]) then [table b] else null
Rupak_bi
Super User
1 year ago
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.