Concat Trick

[bharani8]

Hi Experts - I have attached the qvw file with data loaded.. have four columns in that.. I need to concat those and wanted see like below screen shot in qlikview.. 1st 3 columns concatenating should not be an issue.. 3rd and 4th while merging.. i need the spaces to start from the equal axis.. Any idea?

[prieper]

not clear to me, what the desired outcome should be?

[bharani8]

Plz chk the screen shot i showed .. i need to see like that..

[effinty2112]

Hi Bharani,

The data you have uploaded is the same as your screenshot which was what you said you wanted to achieve.

Col	Colum	Column	Co
WE	12WS	FREIHJY3456	2345R
DE	12DE	WERD45	FREIHJY3456
RF	45RF	2345R	2343RFTY
TG	67YH	2343RFTY	SDFD45
DC	45FB	TYUP	ASF
FV	56HJ	RTED567R4567	WERD45
GB	78JK	ERTDFVY	ASFSG567
HN	98KL	4565YTRE	ASCDV678

Regards

Andrew

[bharani8]

I have uploaded the screen shot from excel... i am trying to replicate the same in qv.. but i cannot.. So looking for some help here

[effinty2112]

Hi,

The table I pasted was from your qvw

Col	Colum	Column	Co
WE	12WS	FREIHJY3456	2345R
DE	12DE	WERD45	FREIHJY3456
RF	45RF	2345R	2343RFTY
TG	67YH	2343RFTY	SDFD45
DC	45FB	TYUP	ASF
FV	56HJ	RTED567R4567	WERD45
GB	78JK	ERTDFVY	ASFSG567
HN	98KL	4565YTRE	ASCDV678

= screenshot of your desired result

[bharani8]

Haha.. I need the concatenated  one in qv

[rohitraut]

hello bharani,

Do you expect output like below?

Col	Colum	Column	Co	COL
RF	45RF	2345R	2343RFTY	2345R2343RFTY
WE	12WS	FREIHJY3456	2345R	FREIHJY34562345R
HN	98KL	4565YTRE	ASCDV678	4565YTREASCDV678
DC	45FB	TYUP	ASF	TYUPASF
GB	78JK	ERTDFVY	ASFSG567	ERTDFVYASFSG567
DE	12DE	WERD45	FREIHJY3456	WERD45FREIHJY3456
TG	67YH	2343RFTY	SDFD45	2343RFTYSDFD45
FV	56HJ	RTED567R4567	WERD45	RTED567R4567WERD45