Forum Discussion
sribmc
Helper I
Helper INeed help in custom column
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 Punj...
Rupak_bi
Super User
Super UserHi 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.