how to reduce table size

[Reuben]

Hi all,

I have two talbles:

1 - Orders

       Orders[date]

       Orders[Order ID]

2- OrdersDetailed

     OrdersDetailed[Order ID]

     OrdersDetailed[SKU]

    OrdersDetailed[QTY]

Tables are linked by [Order ID] columns

Both tables are very big, so I have managed to reduce the firt table size by filtering the table "Orders"  from 2014 year onwards.

My problem is that as the table OrdersDetailed have no data column I dont know how to reduce its size ( It has 2 million lines)

Thank you very much for your feedback.

Rbn

[braddo81]

my database is over 30GB, the largest table is [CatalogItemExtendedContent] and is almost 30GB

can this be cleared out?

[AnkitBI · Accepted solution]

Hi @Reuben 

Can you try merge b/w OrdersDetailed and Orders table to Get OrderDate in OrdersDetailed table. Once done, you can filter OrdersDetailed based on OrderDate

= Table.NestedJoin(OrdersDetailed, {"Order ID"}, Orders, {"Order ID"}, "Orders", JoinKind.Inner)

Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.

[Reuben]

thanks @AnkitBI great job!

[Nathaniel_C]

Hi @Reuben ,

Would it be possible to view the oldest date in your reduced table, look at the Order ID and go to the other table sort the table, and filter out all orders with an ID that is less than your Order ID.  Assuming Order IDs are sequential.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Reuben]

Thanks @Nathaniel_C . The problem is that there is not secuential, depends on the order type

for the type 1 the order ID is Alphanumeric, for the type 2 is numeric.. etc