If I run a subsidiary saved search, what is the sy...
# generald
Dylan Fields
08/07/2023, 7:34 PMIf I run a subsidiary saved search, what is the syntax to pull in the name of the parent? The only selectable field is Parent Subsidiary, but it only brings in the internal ID.
r
raghav
08/07/2023, 7:56 PMI don't think that should be the case. You should be getting the name only, last I remember.
Or you can join with parent and fetch the name.
d
Dylan Fields
08/07/2023, 8:01 PMThis is what I get:
Dylan Fields
08/07/2023, 8:01 PMIf you know how to join, please lmk.
Dylan Fields
08/07/2023, 8:06 PMI've tried parent.name, parent.entityname, parent.subsidiaryname, etc...
Dylan Fields
08/07/2023, 8:11 PMI did it with Analytics; even though I suck at that, when you pull Parent in on that dataset, it pulls the name. 🤷♂️
r
raghav
08/07/2023, 10:53 PMI don't have access to one world account right now, would have checked otherwise.
d
David B
08/09/2023, 5:03 AMcould you use regex in a formula(text)?
REGEXP_REPLACE({name},'( : )?'||{namenohierarchy}||'.*$')David B
08/09/2023, 8:11 AM2 Views