topic Re: loading script- count(distinct) failed in App Development

loading script- count(distinct) failed

emilyrabbit — Wed, 22 Oct 2025 07:19:32 GMT

Hi Buddy, I tried to have a distinct count grouping by 2 fields.

Write below script in the loading script.But I found the distinct didn't work.

TEMP3:
NoConcatenate
Load
[Order Created By Rep]&[Order Year Month] as key,
Count(DISTINCT ([Order Document Number])) as COUNTNUM
Resident FACT_ORDER_FLUID_CONNECTORS
Group BY [Order Created By Rep],[Order Year Month]

Thanks in advance.

Re: loading script- count(distinct) failed

robert_mika — Wed, 22 Oct 2025 07:43:22 GMT

Add the Distinct after load or remove the bracket after DISTINCT(

Re: loading script- count(distinct) failed

hanna_choi — Wed, 22 Oct 2025 07:57:53 GMT

Hello @emilyrabbit

Even if distinct is displayed in black, the result seems to work normally.
The image below is the result of making and processing sample data.

[ Result]

******** No Distinct

[ Result ]

If you share the sample data of "FACT_ORDER_FLUID_CONNECTORS" table

we can think about the problem together.

Re: loading script- count(distinct) failed

marcus_sommer — Wed, 22 Oct 2025 11:28:33 GMT

Be aware that:

[Order Created By Rep]&[Order Year Month] as key,

isn't equally reflected by:

Group BY [Order Created By Rep],[Order Year Month]

and you may need to adjust it to:

Group BY [Order Created By Rep]&[Order Year Month]

Further the combined key has no included delimiter. Depending on the content of the fields there may occur some kind of overlapping.