Help with my Script

[hopkinsc]

Hi,

Can someone tell me what is wrong with my script please?

I am trying to add 2 field names together so they are displayed as 1 list box instead of 2 seperate ones.

Here is my script.

It is trowing up an error that sais

[jonathandienst]

Change the refs to Line Type and Line Description in line 3 back to @1 and @2. These field names do not exist in the data source, so you can't reference them at this point.

Alternatively, do a two level load like this:

Load *,
 [Line Type] & ' - ' & [Line Description] AS [Transaction Type];
Load @1 AS [Line Type],
 @2 AS [Line Description]
From etc etc....

Don't forget the semicolon before the second Load statement.

[hopkinsc]

Excellent, thanks. I used your first suggestion, it has worked now.

Thanks for your help