Forum Discussion
Searching a column in table A using data from a column in table B
Hi Anonymous
"Custom1" is not created with adding a custom column. It is created in the formula bar directly just like below. You can right click #"Renamed Columns2" step, select "Insert Step After" then modify the code in the formula bar.
For the second step, it is created with adding a custom column. But it is not based on the "Custom1" step. Instead, it is based on the previous step of "Custom1". You need to modify the step name.
You can also edit the code in Advanced editor directly. It looks like this.
Best Regards,
Jing
Solution Sagewhen you say "Search", do you mean that they don't have to match exactly, so you can't just do a left join?
Here is a real world example.
The subject of the calendar meeting might say "JOC Mayo Clinic #ABC12 Quarterly Meeting".
My other column from table 2 has "ABC12" and another column that has an ID of 213ABC456.
I need to search "ABC12" with the subject string in Table 1 have Table 1 display in a new column the ID from Table 2.
I have tried this -
maxx(filter( Table2, search(Table1[Program Name], Table2[Assigned Program],,0) >0 ),Table2[LOB]) but it is just giving me blanks.
Thanks!
- kpost
Are you guaranteed to have a hashtag before the value?
If so, could you create a custom column like this that extracts the first string following a hashtag, then do a left join on that column (given the fact that you said the second table is guaranteed to have only one match), or at least get rid of the necessity to "search" the string, and instead you can just match it exactly using a calculated column if you don't want to merge or join the tables?
In either case I think this would simplify things.
I wish that was the case, but no, it might or might not be there.