Many blank or white spaces in Column qlikview

[SK28]

Hi

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

A

B

C

D

E

Present output:

A

B

C

D

E

It has five white spaces or blanks and then data

Required output:

A

B

C

D

E

One blank and remaining data

I need only one blank and remaining data in that column

Thanks in advance.

[sunny_talwar · Accepted solution]

May be this

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

[Anonymous]

Example:

LOAD * Inline [

Recorded

A

B

C

D

E];

Concatenate

LOAD * Inline [

Recorded

''];

[sasiparupudi1]

Could you provide a sample to look into the issue?

[ravikumar_iyana]

you can provide sample data