Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-10-16 10:32 AM

How to set data correctly in columns?

Hi

I have below data executed from SQL query.

country,  Code, closed,   CY,     CusName,   a1,    a2,      a3,      a4,        a5,         Gender,   ref,       Tori,    Joiuy,   Populate,   int

USA          324         Null    554       XX           ejrlgn  btebte  btbte cvdvdrv   POi O90  M        34758573 vnvjv   POland     jdvsv        Yes

When I am copying and pasting the above values with column headers into excel it is showing output as below

country,  Code, closed, CY,      CusName,   a1,    a2,             a3,      a4,           a5,     Gender,   ref,      Tori,  Joiuy,   Populate,   int

ejrlgn     btebte    btbte   cvdvdrv   POi O90      M     34758573  vnvjv   POland     jdvsv      Yes

Would it be possible to set using Qlikview file. Can anyone suggest me please.

Thanks.

275 Views
0 Likes
2 Replies
Not applicable
‎2014-10-16 10:49 AM
Author

I have tried TRIM function but not working for below columns

country,  Code, closed,   CY,     CusName,   a1,    a2,      a3,      a4,        a5,         Gender,   ref,       Tori,    Joiuy,   Populate,   int

please can anyone help me to get this.

186 Views
0 Likes
Not applicable
‎2014-10-16 11:38 AM
Author

In response to

Please can anyone suggest me would it be possible or not?

186 Views
0 Likes