How do I merge 2 fields to create a list object

[#1]

Hi

I have 2 fields in a table that I want to merge together so that it can be used as a list object.

I know how to do this with dates i.e. month & year but I cannot get it to work with the fields below.

I have the following in my script:

ApplyMap ('SupplierMap', StockSupplier, 'unknown') as SupplierName,

StockSupplier as SupplierCode,

I want to be able to merge SupplierName and SupplierCode as Supplier so I can select this as a list object meaning I can make multiple selections.

Any help greatly appreciated.

Steve

[mato32188]

ApplyMap('SupplierMap', StockSupplier, 'unknown') & StockSupplier as Supplier

[Anonymous]

Hi

Below is the Expression

=ValueList($(=concat({1} distinct chr(39) & Col1 & Chr(39),',')),$(=concat({1} distinct chr(39) & Col2 & Chr(39),',')),$(=concat({1} distinct chr(39) & Col3 & Chr(39),',')))

where Col1,Col2,Col3 are column names

Regards

Harsha

[jyothish8807]

Hi Steven

In script try like this:

ApplyMap ('SupplierMap', StockSupplier, 'unknown') & StockSupplier as Supplier

Regards

KC

[Anonymous · Accepted solution]

Hey,

You can do it in the list box properties. By calculating as expression instead of taking a direct column.

expression = suppliercode&' '&Supplerdescription.

Hope this helps.

Best regards,

Chinna

[#6]

Thanks, this has kind of given me what I want but it has broken the rest of the charts in the process.

[#7]

This has worked a treat, thanks. Just need to tidy up the data a bit.