Forum Discussion
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 2:Date2,Cash2 and Table 3:Date 3,Cash 3.
How can I extract specific coloumns and make these 3 seperate tables?
Hi Anonymous ,
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
1 Reply
- MFelix
Super User
Hi Anonymous ,
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