Hi,
We have following set of data where from Field2 till Field6 have "0" & "1" Numeric values. (Int64). We have fixed number of columns in below table. Name column have unique name values.
Input Data ;
| Name | Field2 | Field3 | Field4 | Field5 | Field6 |
| Jack | 1 | 1 | 0 | 0 | 1 |
| Mike | 0 | 1 | 0 | 0 | 1 |
I am expecting below output every row have only one "1" value in column and rest of the column value should become "0".
For next row if same column have value "1" then it should update "0" and other column value should be "1".
The logic is there should be only one time value "1" in each row. If there are multiple "1" then others "1" value should replace with "0".
This logic i need based on group level of Name column.
For example in above table in "Jack" row there are total 3 "1" values found in columns. So workflow should create the 3 records of Jack entries. For example :-
| Name | Field2 | Field3 | Field4 | Field5 | Field6 |
| Jack | 1 | 0 | 0 | 0 | 0 |
| Jack | 0 | 1 | 0 | 0 | 0 |
| Jack | 0 | 0 | 0 | 0 | 1 |
Expected Output : -
| Name | Field2 | Field3 | Field4 | Field5 | Field6 |
| Jack | 1 | 0 | 0 | 0 | 0 |
| Jack | 0 | 1 | 0 | 0 | 0 |
| Jack | 0 | 0 | 0 | 0 | 1 |
| Mike | 0 | 1 | 0 | 0 | 1 |
| Mike | 0 | 1 | 0 | 0 | 1 |
Can you please assist me.
