expanding list column to new table

[Anonymous]

I'm getting my Auditlog data from a Rest Api. The data I get has a lot off nested tables, and I don't have any problems expanding them in the data into records and futher to get the actual data added as columns.

When I expand scanResult and elevatedApplications to "news rows" I end up with two issues. First, my tabel end up with a large number of columns and second each row in the original table is expanded to 57 rows. Performance of the data refresh is terrible.

Is it possible to expand the data into two new tables. One for elevatedApplications and one for scanResult. I would need to copy of the id to the new tables in order to join the tables?

Thanks
Torben

[v-jingzhang]

Hi @Anonymous 

You can first duplicate the original query. Then in the duplicated query, remain only the list column to expand and Id column. Then expand the list column to new rows. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.