Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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......................
may be
Data:
LOAD DISTINCT SubField(NewField,',') as NewField;
LOAD FieldA&','&FieldB&','&FieldC as NewField Inline [
FieldA,FieldB,FieldC
*,*,*
-,-,-
R,S,T
];
Regards,
Antonio
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?
Hi Manchini,
Thanks for your response, Can you please attach the qvw file?
Hi chinnu,
Can you share sample data if you have..........
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
see attached
Attachment
Hi Harikrishna,
I am sharing sample data excels can you please try to join two excels.
Thanks,
Chinnu