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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.