Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qliktech_uk
Contributor III
Contributor III

Group by in preceding load.

Hi,

Is group by allowed in precedingg load?

Or we have to group it in the main load and take the summary data into preceding load?

thanks

3 Replies
Anil_Babu_Samineni

Yes, Allowed

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
rubenmarin

Hi, it should work,I tested with this script:

Data:

LOAD Articulo,

Fecha,

Sum(Ventas) as  Ventas

Group By Articulo, Fecha;

LOAD * Inline

[

Articulo, Fecha, Ventas

A1 ,01/01/2017, 10

A1 ,01/01/2017, 80

A1 ,02/01/2017, 20

A2, 02/01/2017, 30

];

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Be very careful. You will get all sorts of side-effects that you cannot immediately explain. And yes it may work on simple examples. But those are not necessarily what you need in your situation.

Better use simple things in a Preceding LOAD, and do the GROUP BY in a separate operation on an internal table.