Forum Discussion
create new column based on two cells from different with same value
1. Add a new column: Index2 as an index column starting at 2 (one more than column Index)
2. Do a self join (Merge Tables) with Index and Index2 as the key joining columns. Kind of join is left outer
3. Expand the newly generated column to new rows.
4. Now you have duplicate columns in your table with values equal to the previous row.
5. Add a column that compares the current values with the previous values that are stored in the same row.
6. Remove unneeded columns
1. Add a new column: Index2 as an index column starting at 2 (one more than column Index)
2. Do a self join (Merge Tables) with Index and Index2 as the key joining columns. Kind of join is left outer
3. Expand the newly generated column to new rows.
4. Now you have duplicate columns in your table with values equal to the previous row.
5. Add a column that compares the current values with the previous values that are stored in the same row.
6. Remove unneeded columns
It worked really well.
Thank you!!