Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Surya
Creator II
Creator II
‎2020-08-26 08:55 AM

JOINS | ROW NO

Hello,

 

I have Data

orderitemsnofromto
0140000209000010000127-12-201902-01-2020
0140000209000010000215-01-202015-01-2020
0140000209000010000316-01-202016-01-2020
0140000209000010000419-02-202019-02-2020

 

Here Im Passing Order and Item and getting

0030000820|000010
0030000825|000010

below items

I just Join Table

Here Im Getting 8 Items Because 2*4

0140000209000010000127-12-201902-01-20200030000820|000010|
0140000209000010000215-01-202015-01-20200030000820|000010|
0140000209000010000316-01-202016-01-20200030000820|000010|
0140000209000010000419-02-202019-02-20200030000820|000010|
0140000209000010000127-12-201902-01-20200030000825|000010|
0140000209000010000215-01-202015-01-20200030000825|000010|
0140000209000010000316-01-202016-01-20200030000825|000010|
0140000209000010000419-02-202019-02-20200030000825|000010|

 

and in 2nd table also have from and to Date

 fromto
0030000820|00001027-12-201902-01-2020
0030000825|00001016-01-202016-01-2020

 

I'm Expecting Output 

orderitemsnofromto 
0140000209000010000127-12-201902-01-20200030000820|000010|
0140000209000010000215-01-202015-01-2020 
0140000209000010000316-01-202016-01-20200030000825|000010|
0140000209000010000419-02-202019-02-2020 

 

How can I Archive This

Labels (2)
Labels
734 Views
0 Likes
1 Solution

Accepted Solutions
1 Reply