Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

Way to retain Leading number of "spaces" from excel data while loading . If any ?

Hello ,

We all have been trimming unnecessary spaces using trim functions . But i have a requirement where i want to load a column where i need to retain space (number of times space bar pressed , before actual data) .
I am not aware of function to do it  ?

Retaining Spaces.PNG

 

Thanks in advance . 

 

5 Replies
shekhar_analyti
Specialist
Specialist
Author

Hi Sunny Bhai ,  

Can this be achieved in qlik ?

@sunny_talwar 

 

 

sunny_talwar

Have you looked at this?

Verbatim 

sunny_talwar

Capture.png

shekhar_analyti
Specialist
Specialist
Author

Thank You Bhai .. 

KD_
Contributor III
Contributor III

Straight genius