Forum Discussion
Anonymous
3 years agoNot applicable
Merge and Search field
Dear Community,
I am looking for help for what I am sure is a very basic issue.
Below the "data base" where each client could have several order id, so I merged all order id in one column using coma as a separator. I have merged all order id so I could use a search field.
When I search for the client id, no issue but when I search for one (only one) order id on the search field, I have no result.
If someone can help, that will be great.
thanks,
Kasiop
Hi Anonymous ,
You might consider unpivoting the table first.
3 Replies
- djurecic
Super User
Hi Anonymous ,
You might consider unpivoting the table first.
- AnonymousNot applicable
Thanks djurecicK2,
I will try right now...
- AnonymousNot applicable
Thanks again, it worked fine!