Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
bharani8
Creator III
Creator III

Concat Trick

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?

Concat.PNG

7 Replies
prieper
Master II
Master II

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

bharani8
Creator III
Creator III
Author

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

effinty2112
Master
Master

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
WE12WSFREIHJY34562345R
DE12DEWERD45FREIHJY3456
RF45RF2345R2343RFTY
TG67YH2343RFTYSDFD45
DC45FBTYUPASF
FV56HJRTED567R4567WERD45
GB78JKERTDFVYASFSG567
HN98KL4565YTREASCDV678

Regards

Andrew

bharani8
Creator III
Creator III
Author

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

Hi,

The table I pasted was from your qvw

Col Colum Column Co
WE12WSFREIHJY34562345R
DE12DEWERD45FREIHJY3456
RF45RF2345R2343RFTY
TG67YH2343RFTYSDFD45
DC45FBTYUPASF
FV56HJRTED567R4567WERD45
GB78JKERTDFVYASFSG567
HN98KL4565YTREASCDV678

= screenshot of your desired result

Concat.PNG

bharani8
Creator III
Creator III
Author

Haha.. I need the concatenated  one in qv

rohitraut
Creator
Creator

hello bharani,

Do you expect output like below?

Col Colum Column Co COL
RF45RF2345R2343RFTY2345R2343RFTY
WE12WSFREIHJY34562345RFREIHJY34562345R
HN98KL4565YTREASCDV6784565YTREASCDV678
DC45FBTYUPASFTYUPASF
GB78JKERTDFVYASFSG567ERTDFVYASFSG567
DE12DEWERD45FREIHJY3456WERD45FREIHJY3456
TG67YH2343RFTYSDFD452343RFTYSDFD45
FV56HJRTED567R4567WERD45RTED567R4567WERD45