creating new column based on two others

[#1]

Dears,

I have one problem that I am tackling now and no solution serves it right, although probably it is very simple. Maybe you can help?

From two different sources I have two fields [Vendor name] and [Trading partner name] that are already mapped into one table.

Data looks now like this:

doc.           Vendor name          Trading partner name

1                     a                                   

2                     b

3                     c

4                                                           d

5                                                           e

I would like to get data like this:

doc.           Vendor name          Trading partner name      Vendor_final

1                     a                                                                  a

2                     b                                                                  b

3                     c                                                                  c

4                                                           d                            d

5                                                           e                            e

The following solutions do not work for sure:

if([Trading partner name]='',[Vendor name], [Trading partner name]) as Vendor_final,

or

if([Trading partner name]<>'' and [Vendor name] ='',[Trading partner name], if([Trading partner name]='' and [Vendor name] <>'',[Vendor name],'vendor not found'))
as Vendor_final

I will be grateful for any tip.

J.

[SunilChauhan]

everywhere give  spacelike below  ex:' '  in place of ''

if([Trading partner name]=' ',[Vendor name], [Trading partner name]) as Vendor_final

hope this solve your problem

[#3]

It seems not to help. This function results in a Vendor_final column that has only [Trading partner name] as data; [Vendor name] data is not included.

[its_anandrjs · Accepted solution]

Hi,

I think you have to use

If( isnull( [Vendor name]) = -1,[Trading partner name] , [Vendor name] ) as Vendor_final

Rgds

Anand

[#5]

Thank you. That works fine:)