Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - I've created an inline table with the following values:
Keywords:
LOAD * INLINE [
KEYWORD
TICKETS
IPOD
IPAD
CAMERA
APPLE
IWATCH
TV
FEE
CONSULT
MISC
SERVICE
RENDER
LIAISON
TIP
PROCES
FACIL
EXPED
CASH
];
I use these values in a list box and would like to use the selected word(s) to search for matches in the ITEM_DSCR field in my main Purchase Order table as wildcard search. Can someone assist with the proper technique to join these, I've looked at many topics here but am still confused?
Thanks! George
Hello!
You can use Index() function enstead of Wildmatch():
You could use:
'*$(=concat(KEYWORD, '*,*')*'
within a wildmatch() or in a set analysis to restrict either expressions or dimensions.
- Marcus