nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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!

Find more posts tagged with

Accepted answers

All comments

"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.

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 ?

@Gianni Ceresa I totally misread that question 🤣

https://community.oracle.com/tech/apps-infra/discussion/comment/16830104#Comment_16830104

Exactly what I was looking for. Thank you.

I was right? Hahahaha that's a point for me, @Gianni Ceresa

https://community.oracle.com/tech/apps-infra/discussion/comment/16830243#Comment_16830243

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

"column1" || ' ' || "column2"

Thanks alot.