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
Solved! Go to Solution.
Hi @Kasiop ,
You might consider unpivoting the table first.
Thanks again, it worked fine!
Thanks djurecicK2,
I will try right now...
Hi @Kasiop ,
You might consider unpivoting the table first.
User | Count |
---|---|
136 | |
59 | |
56 | |
55 | |
47 |
User | Count |
---|---|
128 | |
76 | |
55 | |
54 | |
51 |