Concat two number fields

[#1]

I have the following table:

Order Number	Line Number
10000	500
20000	750
30000	800
RE-10356	1000

I want to merge the two fields and have the following output as Order-Line numbet:

10000-500

20000-750

30000-800

RE-10356-1000

I am able to concatenate only two text formats, but not number formats.

Can anyone help me please with a Qlikview file/.

[senpradip007]

Try to use like [Order Number] & '-' & [Line Number] As [New Field]

[#3]

it is not working.

it works for date and text formats,.

[senpradip007]

In my app its working fine. Still try like Text([Order Number]) & '-' & Text([Line Number]) As [New Field].

[#5]

No. this is also not working.

[jagan]

Hi,

Try like this

LOAD

*,

Text([Order Number] & '-' & [Line Number]) As [New Field]

FROM DataSource;

Regards,

Jagan.

[senpradip007]

Could you please upload sample app or your script?

[senpradip007]

Have tested with RowNo() & '-' & (RowNo()-1) AS Test2 expressions. Outcome of this expression is like

1-0

2-1

3-2

...

N-(N-1)

[jonathandienst]

Hi

Pradip Sen's answer is correct for your question. If it is not working for you, please provide details of exactly what is wrong, including the output you are getting from the example data in your post. Otherwise we are just guessing...

Jonathan