Facing problem with concatenating different fields into single field..

[chinnu123]

Hi Team,

I am having 3 fields

FieldA    FieldB       FieldC

*               *               *

-               -                 -

R               S               T

I am joining the above 3 fields FieldA & FieldB & FieldC as New Field.

But here I am getting output field as

New Field

---

---R---

ST

***

---S---

---T---

But My output must be like this

New Field

-

*

S

T

R

Is any way to acheive this one, Can any one please help me on this?

Thanks in Advance,

[Kushal_Chawda]

what do you want to achieve based on your sample data?

[chinnu123]

After Concatenating 3 fields in to one field in sample 2 data and then I need to do left join with Sample 1 data

[Kushal_Chawda]

what is expected output you need? both the files having same data

[chinnu123]

Sorry,

By mistake I uploded same files.

Now What I am expecting is In sample 2 data we have fields Field A, Field B, Field C we need to concatenate these 3 fields in to single field and after we need to do  left join this data to sample1data.

[antoniotiman]

Like this ?

[chinnu123]

Yes This is what I need Can you Please share the Qvw

[antoniotiman]

See Attachment.

[chinnu123]

Hi Antonio,

As I observed the records get tripled in your attached qvw when your joining. This is because of using Substring?

Thanks,

Chinnu.

[antoniotiman]

This is the behavior of SubString() function without 3rd parameter