Avoiding Items which doesn't have Vendor Names

[kkkumar82]

Hi All,

Please find below data

Vendor_Name	Item	Component
AFFYMETRIX INC	301110-01	301110-01
	301110-01	301110-01
AFFYMETRIX INC	301130B	301110-01
BERLIN PACKAGING LLC.	301130B	301110-01
Charter Medical	301130B	301110-01
	301130B	301110-01
	105585	301110-01
	301110	301110-01

In fact I was writing a condition like if(isnull(Vendor_Name), Item) but came to know that for eg 301130B

it should not show up as 301130B has other vendors.

The only output I should get is

105585, 301110 as they are not part of another Vendor

Attaching excel of the same

[kkkumar82]

please note that the two expected may have multiple rows but for all of them Vendor Names should be null

[Anonymous]

if(count(total <Vendor_Name> Item) > 0, ...

if(count(total <Item> Vendor_Name) > 0, ...

[sunny_talwar]

May be this in set analysis

{<Item = {"=Len(Trim(Concat(DISTINCT Vendor_Name))) = 0"}>}

UPDATE: Assuming you want to show 105585 and 301110

[kkkumar82]

Does this work when we have multipe rows for 105585 and 301110 Sunny

[sunny_talwar]

As long as each of the row has no Vendor_Name for 105585 and 301110, you will see both the items. In general, when a item (even if there are thousands of rows) doesn't have a Vendor_Name associated with it, it should work....

[Anonymous]

should even work without distinct or?

[kkkumar82]

Let me give a try with my data

[sunny_talwar]

It would... but why complicate by adding multiple values of same vendor name... in fact this might work also (assuming Vendor_Name is null and not contain blank spaces)

{<Item = {"=Count(DISTINCT Vendor_Name) = 0"}>}

[Anonymous]

makes sense