Is there any way to filter the data of one table with data from another table?
Specifically, I have an EnumList where I select the one or the faults of a computer to be repaired. I need to select values from another table according to the selected faults. If the fault is only one, it works perfectly, but if there are several, it looks for the complete text (For example: It does not turn on, it does not give an image) instead of looking for one or the other. The idea was to use the SELECT () function. and filter by any of the values, but I can not apply an OR (Table [Column List]) because it takes it as a single argument.
In another similar case, I use an SPLIT function to generate a list of words from a text, and I need to filter by one of those words, something like OR (SPLIT ([Text], “”)). That does not work because it is a single argument. In both cases I can not think of how to make an OR with the values in the list.
Since already very grateful for any contribution.