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
Hi, do you expect there to be more than 1 match for any row in table A? And if so, how do you want it to handle that?
I would merge query B with query A, and select column 2 from query B. The type of join you want would depend on what relationship you believe exists between the tables (you can test if the relationship is what you expect after, if necessary).
No, each row should only have one match.