How to fill missing values, based on other records in my dataset?

sebasvogsebasvog Member Posts: 7 Newbie
Hello everyone,

I am working on data preperation for training a ML algorithm on a classification problem.
In my dataset (~23000 records) some values (dates) are missing. The dataset looks like in the screenshot below:

Every row is a position on a particular customer order. Every order has a unique Number (column A). Shipping and Invoice Date are only displayed on the last position of the order.
How can i fill the missing values with the matching data (based on "Sales Doc")? The filled dataset should look like this:

I am new in Rapidminer and I would be very thankfull if someone can help me out with this.
Thank you.

Best Answer

Sign In or Register to comment.