I have a table expanded that has an embedded list. The list contains records. Unfortunately, because the lists are applied to each row, it causes the row to be duplicated. So I need to be able to extract the list into columns and somehow get rid of the duplicate rows. There are now unique keys for each row.
There are three records, key, namespace and value. I want to be able to expand the list, but create new columns based on each "key", then populate that column with the data in the corresponding value field. For example, row 1 has list with records of key=account_string, namespace=null (I don't need namespace) and value=45. row 2 may have key=company, value=ab. I would end up with
You can apply "Remove duplicate" on multiple columns (Ctrl + click to choose multiple columns). And then I'd just add an index column or custom column like you mentioned where the column will be mix of your key columns.