Group By

[gigi10]

Hello,

Appreciate your help please.

I am using the "group by" so all the same customer numbers will be consolidated in one line, but it is not working :(

There are still separate line items for same customer number.

[ShankerV]

Hi @gigi10 

As you have used 2 groupby function on customer and customer name it might be the issue.

Where same customer number might have 2 different names.

Many thanks

Shanker V

[gigi10]

They have the same name as well.

[ShankerV]

Hi @gigi10 

Please find the use case below.

Input was:

Many thanks

Shanker V

[ShankerV]

Hi @gigi10 

Can you please share few samples where it is duplicated.

It will help to investigate further.

Many thanks

Shanker V