I would love to see photos. There will naturally be space left on floor where the wall was, so you will have to have some transition from one floor to the other. If you are trying for an open concept room, using a different flooring is not the best way to go. Do you have to take the whole wall down? can you leave a half /knee wall. I do not see this working too well as you described.

Here are a few photos. It opens to the kitchen and to entryway, both with the white tile. Thx for any ideas.