How to keep data in 1 row?

[Vasiliy_Beshentsev]

Good day, everyone!

I have a problem with keeping data in 1 row.

So here is example what i want to achieve:

I load data from 2 different sql servers and some order are keep data in 1 row but sometimes it's not, and put it in 2 rows:

Any suggestion for help?

[timpoismans]

If the first field is the key between data from server1 and data from server2, try a left join.

Though without much knowledge of your data model, it's quite hard to give you a suggestion that might solve your issue.

[Vasiliy_Beshentsev]

Yea, first field is the key.

It's now work for me, i'm trying this already.

It's very strange that some orders a ok but some others are not, and i don't understand why

[Vasiliy_Beshentsev · Accepted solution]

I have found my mistake in data and now everything is great!