Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with the solution for replace blank lines or spaces

Hallo ,,

can any one help with the solution by using treplace or tmap..

I have same data pattern like for one feild..

aaa
bbc-   lll

nnnn

out put need to like aaa bbc- ||| nnn

thanks for early replies

Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hi 
Are they multiple lines in this example? and you just to output one line for all values?
Anonymous
Not applicable
Author

Hi polusani,

I think , you want to remove blank or null values from output.

You can achieve this requirement using tNormalize component. 
Note that In Advanced Setting, checked "Discard trailing empty strings"

Regards,
Amol.