topic Re: General script error in Archived Groups

General script error

Wed, 23 Jul 2025 14:48:52 GMT

Hi Community,

MAP_SINGLE_TAB

Mapping

Load Distinct Tracking_Num,

COUNT(DISTINCT Tracking_NUM_Key) as NB_TRK_NUM_KEY

Resident Trace_Table1

GROUP BY Tracking_Case_NUM;

This is the error i have been facing with app.

General Script Error

Execution Failed

Execution finished.

But the app is working properly in local machine .

I have tested this app by Setting Errormode=0.. Even then i felt the same issue and getting the same prob.

Please suggest anyone on this

Thanks

Satti

Re: General script error

rbecher — Mon, 21 Oct 2013 18:06:15 GMT

Hi Satti,

you cannot have DISTINCT and GROUP BY together. Maybe this works (don't know your field names):

MAP_SINGLE_TAB

Mapping

Load Tracking_Num,

COUNT(DISTINCT Tracking_NUM_Key) as NB_TRK_NUM_KEY

Resident Trace_Table1

GROUP BY Tracking_Num;

- Ralf

Re: General script error

Mon, 21 Oct 2013 18:57:26 GMT

Hi Ralf,

Distinct is working in local machine ....Hence i dont think DISTINCT is the problem.

Re: General script error

rbecher — Mon, 21 Oct 2013 19:00:53 GMT

However, the field(s) of GROUP BY has to be in the field list or aggregation expression..

Re: General script error

Clever_Anjos — Mon, 21 Oct 2013 19:07:33 GMT

Non-grouped fields MUST exists at GROUP BY clause

MAP_SINGLE_TAB

Mapping

Load Distinct Tracking_Num,

COUNT(DISTINCT Tracking_NUM_Key) as NB_TRK_NUM_KEY

Resident Trace_Table1

GROUP BY Tracking_Case_NUM;

should be

MAP_SINGLE_TAB

Mapping

Load Distinct Tracking_Num,

COUNT(DISTINCT Tracking_NUM_Key) as NB_TRK_NUM_KEY

Resident Trace_Table1

GROUP BY Tracking_Case_NUM,Tracking_Num;

Re: General script error

Mon, 21 Oct 2013 19:12:45 GMT

OK. However i have used Errormode=0 , which means it should continue reload of app even it has an error .

then why it has thrown an error.

Re: General script error

rbecher — Mon, 21 Oct 2013 19:16:06 GMT

But what should it do? Don't load the mapping table? Then you will have more errors later using the mapping table.. And more errors.. And so on.

Re: General script error

Mon, 21 Oct 2013 19:16:12 GMT

by mistake i have given tracking_case_num in the group by clause . but in the qlikview script i have given right script

Re: General script error

rbecher — Mon, 21 Oct 2013 19:17:20 GMT

Then post the right script here..

Re: General script error

Mon, 21 Oct 2013 20:08:03 GMT

Guys,

Really shocked .

I have given Mapping load distinct in a single line(the following script) . It's working now.

Mapping_shot:

Mapping Load Distinct

Tracking_Num,

COUNT(DISTINCT Tracking_NUM_Key) as NB_TRK_NUM_KEY

Resident Trace_Table1

GROUP BY Tracking_Num;

Thanks

Satti

Re: General script error

rbecher — Mon, 21 Oct 2013 20:10:12 GMT

However, you should omit DISTINCT. It is not needed nor makes sense here..

- Ralf

Re: General script error

Anonymous — Mon, 21 Oct 2013 20:18:14 GMT

There should be something else. Single line or multi-line makes no difference (unless you break the words of course). That is,

MAPPING LOAD DISTINCT

and

MAPPING

LOAD

DISTINCT

are exactly the same...

Regards,

Michael

Re: General script error

Fri, 10 Jan 2014 06:54:38 GMT

Hi Michael

You are right it will keep both are meaning less it will degrade the load performance of the script

Thanks & Regards,

Radha krishna