Categories
- All Categories
- Oracle Analytics Learning Hub
- 25 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to lock 2 columns together ( First Name, Last Name )
Hello, I'm trying to lock first name column and last name column together, so that when I pull results it will not give me every person that has the first name but not the last name and vice versa. I tried to use a filter that uses the AND function, but its still pulling different results. TIA!
Answers
-
"lock together" - you mean CONCATENATE?
Like
"First Name" | "Last Name"
--------------------------------
Testy | MyTestface
should become
"Full Name"
---------------
Testy McTestface
?
Two options:
1.) CONCAT ( "column1", "column2")
2.) "column1" || "column2"
Just open the f(x) formla editor in Analytics / Calculations f(x) in DV and all the functions are explained there.
0 -
I probably got your question wrong...
it will not give me every person that has the first name but not the last name and vice versa
Did you try FIRST_NAME is not null AND LAST_NAME is not null ?
0 -
@Gianni Ceresa I totally misread that question 🤣
0 -
Exactly what I was looking for. Thank you.
0 -
I was right? Hahahaha that's a point for me, @Gianni Ceresa
0 -
Yes, haha One problem, I'm trying to add a space between the first and last name cant get them to separate? Tried
"column1" || "column2"
I made sure that they have a space but its still combining them. TIA
0 -
"column1" || ' ' || "column2"
0 -
Thanks alot.
0
