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
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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: 
Anonymous
Not applicable
‎2014-08-16 07:51 AM

Complex Join in Load Script

Hello,

I need to perform a join between these two tables:

T_MASTER:

ID_MASTERDESC_MASTER
IDM01Master Element 1
IDM02Master Element 2
.......

T_DETAIL

ID_DETAILDESC_DETAILDETAIL_USED_IN
IDD01Detail Element 1

IDM01

IDM05

IDM10

IDD02Detail Element 2

IDM02

IDM04

To get this final table:

T_USED_IN:

ID_MASTERID_DETAIL
IDD01IDM01
IDD01IDM05
IDD01IDM10
IDD02IDM02
IDD02IDM04

Any clue will be appreciated.

Regards,

Javier

Labels (1)
Labels
2,391 Views
0 Likes
10 Replies
MarcoWedel
MVP
MVP
‎2014-09-20 03:01 AM

In response to MarcoWedel

Please mark as answered if there are no further questions.

Thanks

Regards

Marco

197 Views
0 Likes