Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vasiliy_Beshentsev
Creator III
Creator III

How to keep data in 1 row?

Good day, everyone!

I have a problem with keeping data in 1 row.

So here is example what i want to achieve:

2018-09-28 12_47_49-Qlik Sense Desktop.png

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:

2018-09-28 12_43_47-Qlik Sense Desktop.png

Any suggestion for help?

1 Solution

Accepted Solutions
Vasiliy_Beshentsev
Creator III
Creator III
Author

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

View solution in original post

3 Replies
timpoismans
Specialist
Specialist

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
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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