Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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/.
Try to use like [Order Number] & '-' & [Line Number] As [New Field]
it is not working.
it works for date and text formats,.
In my app its working fine. Still try like Text([Order Number]) & '-' & Text([Line Number]) As [New Field].
No. this is also not working.
Hi,
Try like this
LOAD
*,
Text([Order Number] & '-' & [Line Number]) As [New Field]
FROM DataSource;
Regards,
Jagan.
Could you please upload sample app or your script?
Have tested with RowNo() & '-' & (RowNo()-1) AS Test2 expressions. Outcome of this expression is like
1-0
2-1
3-2
...
N-(N-1)
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