About the expression

[#1]

Hello;

I have this sentence in my table expression:

concat({<Type={'Store'}>}Model,' ; ')

I want to insert all new Models in new line (Instead to separate the models with ";" sign)

How can I do this?

Elad

[#2]

seems right. What kind of error you get?

concat(Distinct Name,' ; ') is the code. How he works without set analys?

[#3]

Instead of them all being on one line, you want them all to be on separate lines?

If so, then you need to add Model as a dimension.

[johnw]

Put the new line between the quotes. You may also need the "distinct" keyword depending on your data model.

concat({<Type={'Store'}>} distinct Model,'
')

[boorgura]

You can use chr(10) in place of ' ; '.

chr(10) is equivalent to next line.

[#6]

I use chr(13) for new lines.

[boorgura]

chr(10) maps to new line

chr(13) maps to carriage return... finally doing the same thing