List box issue

[amit_saini]

Hi Folks ,

I'm calling excel sheet with script below:

LOAD  left(A,3) as Plant,

     B as Region,

     C as Plant_FullName,

     D as Business_Units

FROM

(ooxml, no labels, table is Sheet1);

In list box I'm calling this expression :

=Plant & ' - ' & Plant_FullName

Output is:

No idea why this '-' is present in list box , Kindly help here I don't want this - in Plant list.

Thanks,

AS

[PrashantSangle · Accepted solution]

Hi,

Change your expression to

if (not isnull(Plant),Plant & ' - ' & Plant_FullName)

or

if (not isnull(Plant) and not isnull(Plant_FullName),Plant & ' - ' & Plant_FullName)

Regards

[PrashantSangle]

Hi,

Try this also

if(len(trim(Plant))>0,Plant & ' - ' & Plant_FullName)

or

if(len(trim(Plant))>0 And len(trim(Plant_FullName))>0,Plant & ' - ' & Plant_FullName)

Regards

[senpradip007]

Could you please upload sample qvw? I think Plant and Plant_FullName contain any null value.