Distinct in Load

[#1]

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?

[Chanty4u · Accepted solution]

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;

sid	name	sales	profit	Year	Month
123	wrr	4580	699	2014	jan
345	rere	547	665	2015	feb
346	aa	548	666	2016	mar
347	fe	549	667	2014	apr
348	aa	550	668	2015	may
349	rere	551	669	2016	jun
350	fsf	552	670	2016	jul
355	sf	553	671	2014	aug
355	f	554	672	2015	sep
355	sf	555	673	2016	oct
350	sf	556	674	2014	nov
355	sffsw	557	675	2014	dec
356	wrr	558	676	2015	jan
357	sfsf	559	677	2016	feb
358	wrr	560	678	2015	mar
359	tg	561	679	2016	apr
351	sf	553	671	2014	aug
352	f	554	672	2015	sep
353	sf	555	673	2016	oct
354	sf	556	674	2016	nov
355	sffsw	557	675	2014	dec
356	wrr	558	676	2015	jan
357	sfsf	559	677	2016	dec
358	wrr	560	678	2015	mar
359	tg	561	679	2016	apr

[#3]

Thanks.

[Anonymous]

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

Can you elaborate on your requirement?