cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rajatahuja Frequent Visitor
Frequent Visitor

Extract columns from Table and make new tables

Hi,

I have a table(attached) and I want to make 3 seperate tables out  of it. Table 1 : Date 1,Cash1. Table 2Smiley Very Happyate2,Cash2 and Table 3Smiley Very Happyate 3,Cash 3.

How can I extract specific coloumns and make these 3 seperate tables?

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Extract columns from Table and make new tables

Hi @rajatahuja ,

 

If you pick the same source file you can on the query editor remove the columns you don't want. On one table remove last four, on second table first two and last two, and on last table last 4 columns.

 

Your model will only save the final steps so no additional data.

 

Check PBIX file attach.

 

Regards,

MFelix

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: Extract columns from Table and make new tables

Hi @rajatahuja ,

 

If you pick the same source file you can on the query editor remove the columns you don't want. On one table remove last four, on second table first two and last two, and on last table last 4 columns.

 

Your model will only save the final steps so no additional data.

 

Check PBIX file attach.

 

Regards,

MFelix

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!