cancel
Showing results for 
Search instead for 
Did you mean: 

Newbie - Query Transform question?????

Former Member
0 Kudos

I am new to this data tool. Is it possible to cancate two values in the mapping section of the query transform.

What I am trying to do is I have two columns if Column B is null actually <Blank> I want the value from column A if Column B is not <Blank> then I want to cancate the two value together.

What is the best way to do this.

Accepted Solutions (1)

Accepted Solutions (1)

former_member106536
Active Participant
0 Kudos

What is wrong with just concatenating a blank field to the end of field A?

field.A || field.B

the hard way:

ifthenelse(field.B = '' or field.B is null, field.A, field.A || field.B)

you may also want to concat using a delimiter or rpad field A with spaces, to maintain position.

Former Member
0 Kudos

Thank-you very much all, for the very quick responses

Answers (1)

Answers (1)

shanthi_bhaskar
Active Contributor
0 Kudos

WELCOME TO SDN

usually concatenating is possible in the transfomation layer only