topic Re: Many blank or white spaces in Column qlikview in QlikView

Many blank or white spaces in Column qlikview

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

I have a column name RECORDED

which is a free text column

When i had loaded it in qlikview

I saw many white spaces or blanks in List box

Example

Recorded

Present output:

It has five white spaces or blanks and then data

Required output:

One blank and remaining data

I need only one blank and remaining data in that column

Thanks in advance.

sunny_talwar — Tue, 27 Mar 2018 19:50:31 GMT

May be this

If(Len(Trim(RECORDED)) = 0, ' ', RECORDED) as RECORDED

Anonymous — Tue, 27 Mar 2018 19:55:19 GMT

Example:

LOAD * Inline [

Recorded

E];

Concatenate

LOAD * Inline [

Recorded

''];

sasiparupudi1 — Wed, 28 Mar 2018 11:17:18 GMT

Could you provide a sample to look into the issue?

ravikumar_iyana — Wed, 28 Mar 2018 11:49:22 GMT

you can provide sample data