cancel
Showing results for 
Search instead for 
Did you mean: 

Concatenation for multiple source elements

Former Member
0 Kudos
51

Hi,

Simple question for you guys - trying to understand concatenation correctly.What is the output if 2 source fields have mulitple elements eg:

Is:

Field1

Joe Blogs

Field2

21 Normal Road

Simply concatenated to:

Target

Joe Blogs 21 Normal Road

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

This is really very simple..

Yes, the output will be like that only but without any space..

Why don't you try this on your machine before posting it.

Regards,

Sarvesh

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

If you have got the ans, then make this thread as answered.

Regards,

Sarvesh

former_member193376
Active Contributor
0 Kudos

Hi

By default if you do not set any delimeter, there will not be a space between your 2 fields. Experiment and try out first before posting.

Thanks

Saiyog

markangelo_dihiansan
Active Contributor
0 Kudos

Hi,

There is an option for a delimiter in the Concat function, if you set it to the default [], the output would be Joe Blogs21 Normal Road.

Regards,