Distinct in Load

Thu, 10 Nov 2016 10:51:51 GMT

Hello,

I load the following fields:

Inventory No,

Storage Place,

Document No

I don't want duplicates in the Inventory No.

Can someone help me?

Re: Distinct in Load

Chanty4u — Fri, 11 Nov 2016 06:38:31 GMT

Hi ,

chechk below sample example:

LOAD sid,

FirstValue( name) as name,

FirstValue( sales) as sale,

FirstValue( profit) as pro,

FirstValue(Year) as year,

FirstValue( Month) as month

FROM

(ooxml, embedded labels, table is Input)

Group by sid;

Fri, 11 Nov 2016 07:07:17 GMT

Thanks.

Anonymous — Fri, 11 Nov 2016 10:53:22 GMT

Do this "Inventory No" has different "Storage Place" and "Document No"?

Can you elaborate on your requirement?