Data grouping

[prma7799]

Hi All,

I have one field called customer in that have many records , So I want to do grouping on that same records.

Please see below image I have customer name base on customer name i want Customer Grouping field as like below

Ex Output .

[settu_periasamy]

Your excel is file Merged with Rows (some data) in the Customer Grouping Name filed.

We can fill the Null values the using the  Enable Transformation Wizard.. See the below picture..

this will create the script, filters(Replace(4, top, StrCnd(null))));

[prma7799]

Hi settu_periasamy‌ , Kush141087‌

Settu I am using your solution, getting blank values in table box

please see below

[settu_periasamy]

Yes, There is 137 customers only available in your "CustomerGrouping" Excel File. But, In your Customer QVD file contains nearly 2000 customers.

[prma7799]

Hisettu_periasamy‌,

What will I do for that 2000 customers which is showing me null.

Thanks