Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
chinnu123
Creator
Creator

Facing problem with concatenating different fields into single field..

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,

18 Replies
Kushal_Chawda

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

chinnu123
Creator
Creator
Author

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
Creator
Creator
Author

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
Master III
Master III

Like this ?

chinnu123
Creator
Creator
Author

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

antoniotiman
Master III
Master III

See Attachment.

chinnu123
Creator
Creator
Author

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
Master III
Master III

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