Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
account_string company
45 ab
Hope that make sense. Thanks in advance.
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.
Hope that makes sense!
Thanks. My bigger issue is getting the "list" expanded and converted into columns. That is where I am struggling. I have looked at list.transform, etc but have not had good luck yet.
User | Count |
---|---|
140 | |
113 | |
104 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |