I would like to Concatenate [CustomerID] and [SiteID] in my APP and Lower the letters and user substitute to put everything together without spaces.
The final result would be like: customernorthoffice.
Iโve tried to combine them all but no luck. Appreciate your help.
User | Count |
---|---|
17 | |
11 | |
7 | |
3 | |
2 |