Forum Discussion
Nested column to new table
Hi LeviCaers,
I have tried alena2k's function and added some steps that you could refer to:
Sample data:
Add customer column in Table A:
Expand it and format the Customer.Number as Text:
Add customer column:
Remove the other columns and you could see the correct result.
You could also download the pbix file the have a view:
https://www.dropbox.com/s/j8qlxt9vla8uns7/Nested%20column%20to%20new%20table.pbix?dl=0
Regards,
Daniel He
Hi LeviCaers,
I have tried alena2k's function and added some steps that you could refer to:
Sample data:
Add customer column in Table A:
Expand it and format the Customer.Number as Text:
Add customer column:
Remove the other columns and you could see the correct result.
You could also download the pbix file the have a view:
https://www.dropbox.com/s/j8qlxt9vla8uns7/Nested%20column%20to%20new%20table.pbix?dl=0
Regards,
Daniel He