2 ms·
Excel merge supports joins, and you can do ordinary SQL joins using Power Query. I don't know if it full complies with all of Codd's 12 rules, I suspect it prob
by AmericanChopper 6y ago
Excel merge supports joins, and you can do ordinary SQL joins using Power Query. I don't know if it full complies with all of Codd's 12 rules, I suspect it probably doesn't fully meet the schema definition or non-subversion bits, but I haven't looked into it closely enough, the Excel Data Model functionality looks like it might actually do that.