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

Use below script...

Data:

LOAD * Inline [

FieldA,FieldB,FieldC

*,*,*

-,-,-

R,S,T

];

Final:

CrossTable(Field,Data,1)

LOAD

'' as dummy,

FieldA,FieldB,FieldC

Resident Data;

DROP Table Data;

or

see the attached qvw......................

antoniotiman
Master III
Master III

may be

Data:
LOAD DISTINCT SubField(NewField,',') as NewField;
LOAD FieldA&','&FieldB&','&FieldC as NewField Inline [
FieldA,FieldB,FieldC
*,*,*
-,-,-
R,S,T
]
;

Regards,

Antonio

chinnu123
Creator
Creator
Author

Hi Hari Krishna,

Thanks for your quick reply

Its working fine and getting desired output but here problem is I am having a some other fields also in that table

and I need to join that table to another table here How can we do this?

chinnu123
Creator
Creator
Author

Hi Manchini,

Thanks for your response, Can you please attach the qvw file?

hari8088
Creator
Creator

Hi chinnu,

Can you share sample data if you have..........

chinnu123
Creator
Creator
Author

Hi Hari Krishna,

As I said earlier I have a fileds FiledA, FieldB,FieldC we joined these 3 fields in to 1 field by using cross table

But I am having Remaining Fields like Customer,Income,Investment fields in the same table.

Now I need to join  these table to another Table As per your syntax I am not able to load these remaining fields in to that Final Table.

Hope I am Clear

Kushal_Chawda

see attached

antoniotiman
Master III
Master III

Attachment

chinnu123
Creator
Creator
Author

Hi Harikrishna,

I am sharing sample data excels can you please try to join two excels.

Thanks,

Chinnu