How to write calculated field in the script

[#1]

Hello

Help me to write calculated field in the script, please:

COUNT(TOTAL <Field1> DISTINCT Field2) as Field3,

it's works in the pivot table, but don't works in script.

[its_anandrjs]

In load script you have to aggregate the count with dimensions.

See the example for this

Source:

Load

Field1,

Field2,

Field3

From Locaition;

Final:

Load

Field1,

Field2,

Count(Field3) as Field3

Resident Source

Group by Field1,Field2;

Drop table Source;

[Joseph_Musekura]

Hi

See attached sample with 2 alternatives.

Thanks