Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Sorry if I'm a bit unclear. I try to put together different names together to one and can pick everything thereafter. I don't actually know how to think or how to do it.
Let us say I have those names:
HB1010X002Y01Z12
HB1010X002Y01Z21
HB1010X002Y01Z22
HB2020X002Y03Z21
HB2020X002Y03Z22
HB2020X002Y04Z21
I want them to be grouped up to HB1010. Because the location names have a starting name with HB1010X002Y02Z21
Same as HB2020 etc.
Any expressions to think about?
Create a new field like this
Left(FieldName, 6) as LocationName,
FieldName
Now, if you will select HB1010 in LocationName, it will select all those FieldName, where the first 6 are HB1010