Let me know if there’s a better way to do this than using 2 datatables and comparing. I would like to query a table that CONTAINS wildcards.
I receive a CSV with the following values, which we’ll call table1:
Description ALKEYVALUE12375 jad8fh nonsense099383 AKKEYVALUE13878 j kd ike nonsense 81839 kd
I would like to compare it to another CSV (table2) that contains the KEYVALUE portion of the description, and return the associated state. Layout of table2:
State | Description AL | ALKEYVALUE* AK | AKKEYVALUE*
The only way I can think of making this work is to nest 2 for each loops where it goes through each row of table1, and then compares it to each row in table2. However, this seems very inefficient. Is there a better way of doing this?