Forum Discussion
Filter Rows which don't start with letter defined in another table
If Anonymous's solution doesn't work, I recommend using Power Query to achieve this. You can do this with a couple of transformations and then using Merge to create a new table with the desired output.
You can refer to the Applied Steps in each of the respective tables to see what I did to get the output. However, the most important thing is that prior to Merging the tables, you create a new column in each table that will be used as the relationship that ensures the merge occurs correctly. I have created the 'validityCheck' column in each table and that is the basis of the Merge.
The output will look like this:
Hope this helps!
Theo
If Anonymous's solution doesn't work, I recommend using Power Query to achieve this. You can do this with a couple of transformations and then using Merge to create a new table with the desired output.
You can refer to the Applied Steps in each of the respective tables to see what I did to get the output. However, the most important thing is that prior to Merging the tables, you create a new column in each table that will be used as the relationship that ensures the merge occurs correctly. I have created the 'validityCheck' column in each table and that is the basis of the Merge.
The output will look like this:
Hope this helps!
Theo
TheoC I recommended using the Query Editor (Power Query) and it will work. 😊
Anonymous I agree with you that Query Editor / Power Query can achieve it with ease. It's just making sure that there is clarity in establishing a relationship between the Rule and Transaction table to allow the filerting process to occur effectively.