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

Creating New Tables From One Existing Table

Hello Folks,  

 

Please let me know how to create new table from one Big table. I want to create 3-4 small tables from one big table by applying some filters in it.

 

In output 1, i need only 3 columns i.e. [ Product | Qty | Size ] with one condition i.e. Size = Large, as shown below

 

In output 2 need only 2 columns i.e. [ Product | Qty ] with one condition i.e. Sex = Female, as shown below

 

 

WhatsApp Image 2017-11-27 at 2.28.39 PM.jpeg

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Creating New Tables From One Existing Table

Hi @gaurav1991,

 

OutPut1 =
SELECTCOLUMNS (
    FILTER ( TableName, TableName[Size] = "Large" ),
    "Product", TableName[Product],
    "Qty", TableName[Qty],
    "Size", TableName[Size]
)

1.PNG

 

OutPut2 =
SELECTCOLUMNS (
    FILTER ( TableName, TableName[Sex] = "Female" ),
    "Product", TableName[Product],
    "Qty", TableName[Qty]
)

2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Creating New Tables From One Existing Table

Hi @gaurav1991,

 

OutPut1 =
SELECTCOLUMNS (
    FILTER ( TableName, TableName[Size] = "Large" ),
    "Product", TableName[Product],
    "Qty", TableName[Qty],
    "Size", TableName[Size]
)

1.PNG

 

OutPut2 =
SELECTCOLUMNS (
    FILTER ( TableName, TableName[Sex] = "Female" ),
    "Product", TableName[Product],
    "Qty", TableName[Qty]
)

2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gaurav1991 Frequent Visitor
Frequent Visitor

Re: Creating New Tables From One Existing Table

@v-yulgu-msft

 

Thanks, Its Done!