Create table based on value from existing table using power query

Question

Hi All,I have two tables.Table A:&nbsp;Date&nbsp;NameValue27-07-2020AP12327-07-2020AS45627-07-20220SK34526-07-2020AP78926-07-2020SK32025-07-2020AS145Table B:NameAPASSKI want my output table as below:DateNameValue27-07-2020AP12327-07-2020AS45627-07-20220SK34526-07-2020AP78926-07-2020SK32026-07-2020AS025-07-2020AS14525-07-2020AP025-07-2020SK0How to achive this in power query ?Thanks,Aswini

mariusz · Accepted Answer

Hi&nbsp;aswiniharidas19&nbsp;
&nbsp;
Please see the attached solution that will return the below result

&nbsp;
Best Regards,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me. LinkedIn 
&nbsp;

Forum Discussion

Create table based on value from existing table using power query

2 Replies

Related content

Lakehouse Table Generate Create Table

Create new table

Cannot create liquid clustering on existing unpartitioned table

Create a new table from columns from existing tables

Create rows from 2 tables

Date	Name	Value
27-07-2020	AP	123
27-07-2020	AS	456
27-07-20220	SK	345
26-07-2020	AP	789
26-07-2020	SK	320
25-07-2020	AS	145