topic Script loading 2 fields/column names together? in QlikView

Script loading 2 fields/column names together?

Fri, 02 Sep 2011 17:23:10 GMT

Hello,

Can someone provide me a script with which i can load two field names combining one?

Load

[Document number],

[Item number]

From

xxx

So the results would be something like (totally made this up)=> [Document number] & "/" & [Item number] As [DocItem]

Values would look something like this

10004500/001

Can someone help?

Fri, 02 Sep 2011 17:51:54 GMT

Found the answer in a previous post

Sokkorn — Sat, 03 Sep 2011 02:33:51 GMT

Hi,

Try this :

Load

[Document number] & '/' & [Item number] As [DocItem]

From tblName;

Regards,

Sokkorn