Forum Discussion

yogeshmaney's avatar
yogeshmaney
Helper I
6 years ago
Solved

CreateTable in Power Query

Hello,   In PowerQuery, How can we use Create Table from an existing table by filtering rows?    Thanks  
Need Help
  • yogeshmaney's avatar
    yogeshmaney
    6 years ago

    Hi

    I referenced DataSet &

    Tried Following

     

    let
    Source = Data1,
    #"Added Custom" = Table.AddColumn(Source, "Index", each if [Location] = "US" then "" else 0/1),
    #"Changed Type" = Table.TransformColumnTypes(#"Added Custom",{{"Index", type binary}}),
    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Changed Type", {"Index"}),
    #"Removed Columns" = Table.RemoveColumns(#"Removed Errors",{"Index"})
    in
    #"Removed Columns"

     

    Its Working for me. 

Geradav's avatar
Geradav
Responsive Resident
6 years ago

Great! Glad you found something that works for you yogeshmaney 

 

I guess you could simplify that M code with:

let
Source = = Table.SelectRows(
   Data1,
   each [Location] = "US"
)
in Source

 

 

Best

 

David 

yogeshmaney's avatar
yogeshmaney
Helper I
6 years ago

David  That's Filtering Column. Data I am fetching is from Event Store. Each Referencing is around 750 MB . Need 20-25 such reference. And Making File heavy. Inside there are JSON blobs.

Deleting is the only option