I have been looking for this off and on for 3 years, can someone help? I've put a ticket in and they aren't able to help without charging and I just don't understand why this isn't a simple answer. I don't know know or have access to SQL and neither does anyone else at our organization.
What I need:
I need to be able to add address line 1 in list criteria so I can search based on the address containing a word, like a street. For example, I want to pull everyone with an address that contains "Tropical Av"
What I know/currently have tried:
I hope that comes through clear, but in summary I have added Address Street 1 to T_Keyword, Detail Tbl of vs_addrss and Detail Col of !.street1
I appreciate any help you can offer!
Jen
Jen,
It might be easier if you add a List Manager element - we have one for just this purpose. In T_KEYWORD add a new item with the values:
That way, team members who're put off by adjusting code can use it.
Martin
Martin, thank you! This is what I was trying to do, but it wasn't working. I had all of this except the "category", so I guess that was it! Thank you thank you!
I had this too, but dm took another route. NOTE: w hen you train people on using it, be sure to train them to use % often. E.g. there are a lot of spelling variations for unknown like X, xx, xxxxx, not known, unsupplied, st instead of dr, etc in our data. I'm always adding some new variant to the extraction postal mail exclusions :)
absolutely! But at this time, I won't be training anyone as I'm the only one who currently pulls lists.