topic Re: Facing problem with concatenating different fields into single field.. in QlikView

Facing problem with concatenating different fields into single field..

chinnu123 — Wed, 25 Nov 2020 16:16:04 GMT

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

***

---S---

---T---

But My output must be like this

New Field

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

Thanks in Advance,

Re: Facing problem with concatenating different fields into single field..

hari8088 — Wed, 04 Oct 2017 10:15:03 GMT

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;

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

Re: Facing problem with concatenating different fields into single field..

antoniotiman — Wed, 04 Oct 2017 10:49:11 GMT

may be

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

Regards,

Antonio

Re: Facing problem with concatenating different fields into single field..

chinnu123 — Wed, 04 Oct 2017 10:51:27 GMT

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?

Re: Facing problem with concatenating different fields into single field..

chinnu123 — Wed, 04 Oct 2017 10:58:31 GMT

Hi Manchini,

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

Re: Facing problem with concatenating different fields into single field..

hari8088 — Wed, 04 Oct 2017 11:05:49 GMT

Hi chinnu,

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

Re: Facing problem with concatenating different fields into single field..

chinnu123 — Wed, 04 Oct 2017 11:26:34 GMT

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

Re: Facing problem with concatenating different fields into single field..

Kushal_Chawda — Wed, 04 Oct 2017 11:27:10 GMT

see attached

Re: Facing problem with concatenating different fields into single field..

antoniotiman — Wed, 04 Oct 2017 11:34:08 GMT

Attachment

Re: Facing problem with concatenating different fields into single field..

chinnu123 — Wed, 04 Oct 2017 13:32:47 GMT

Hi Harikrishna,

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

Thanks,

Chinnu

Re: Facing problem with concatenating different fields into single field..

Kushal_Chawda — Wed, 04 Oct 2017 13:41:04 GMT

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

Re: Facing problem with concatenating different fields into single field..

chinnu123 — Wed, 04 Oct 2017 13:45:00 GMT

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

Re: Facing problem with concatenating different fields into single field..

Kushal_Chawda — Wed, 04 Oct 2017 13:48:48 GMT

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

Re: Facing problem with concatenating different fields into single field..

chinnu123 — Wed, 04 Oct 2017 14:01:23 GMT

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.

Re: Facing problem with concatenating different fields into single field..

antoniotiman — Wed, 04 Oct 2017 14:13:59 GMT

Like this ?

Re: Facing problem with concatenating different fields into single field..

chinnu123 — Wed, 04 Oct 2017 14:17:03 GMT

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

Re: Facing problem with concatenating different fields into single field..

antoniotiman — Wed, 04 Oct 2017 14:43:52 GMT

See Attachment.

Re: Facing problem with concatenating different fields into single field..

chinnu123 — Thu, 05 Oct 2017 14:38:34 GMT

Hi Antonio,

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

Thanks,

Chinnu.

Re: Facing problem with concatenating different fields into single field..

antoniotiman — Thu, 05 Oct 2017 14:44:54 GMT

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