Optimizing the search box using qualify fields

[vikasmahajan]

tgh

[settu_periasamy]

Hi Vikas,

I think it will work, Could you Please post the sample data? Let us try it..

[vikasmahajan]

Thanks Settu I post sample please give some time

Thanks

Vikas

[vikasmahajan]

PFA Sample data

Vikas

[settu_periasamy · Accepted solution]

Hi Vikas,

I think it is working for me. Can you check the attachment..

Note: We need to select atleast one table

[vikasmahajan]

Thanks Settu

[tresesco]

Try list of fields - expression like:

=Concat(IF(WildMatch($Field, '*'& %Initative &'*'), $Field), ',')

You might want to deal the cases separately when nothing/multiple values are selected.

[vikasmahajan]

TableN:

Load inline [

TableName

Abc*

PQR*

XYZ*

];

=TableName&';Region;Country Name;CIO Group;CTO Group'

This way it is sorted thanks

Vikas