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,

[hari8088]

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]

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]

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]

Hi Manchini,

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

[hari8088]

Hi chinnu,

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

[chinnu123]

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]

Attachment

[chinnu123]

Hi Harikrishna,

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

Thanks,

Chinnu