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.
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
They have the same name as well.
Please find the use case below.
Input was:
Can you please share few samples where it is duplicated.
It will help to investigate further.