Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Please can anyone suggest me would it be possible or not?