Forum Discussion
how to reduce table size
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
Hi Anonymous
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.
5 Replies
Hi Anonymous ,
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.
NathanielThanks 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
Hi Anonymous
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.thanks AnkitBI great job!
