I’ve table in below format and I want to group it as below
Column A to F are data columns and in column G, I’ve mentioned how data should be grouped. The grouping should be done as below:
- Group by column A, having various combinations of values from Column D,E and F i.e. grouping based on non zero values of columns D,E and F. For example, Column A = 100, Value1 and Value2 are non zero - Row no 2 and 4 grouped as Group A
- Group B : ColumnA and only Value1 is non zero and Value2, Value 3 are 0
- Group H : ColumnA and only Value2 = 0 and Value1, value3 are non zero.
Likewise grouping needs to be done and loaded into queue. I’ve tried group by on columns A,D,E,F together but it works only if column D,E,F from multiple rows have same values. However, it should group data based on permutation and combinations of columns containing data of Column D,E and F, irrespective its non zero value, for given Column A value.
Appreciate your help!
Thanks in advance.