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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

2 seperate databases

I have a program that list all users connected to our alarmcenter and their contact person. The user and the contact persons information seems to be located in 2 seperate databases (database tables) and when i import it into clickviewer i cant seem to get all the information into a table box the way i want. What i end up with is the contact information shows up after the user information like this.

UserPhoneContact
User 1Phone 1
User 2

Phone 2

Contact 1
Contact 2

But what i need is more like this

UserPhoneContact
User 1Phone 1Contact 1
User 2Phone 2Contact 2

Hope you understand what i want, and that someone can help

10 Replies
Not applicable
Author

This is how my script looks like now

DBC CONNECT TO triggerII;

LOAD Address,

    AlarmCode,

    "Department_Name",

    DoorCode,

    FirstName,

    ImportantInformation,

    Information,

    KeyInformation,

    LastName,

    ProtectedIdentity,

    RoadDescription,

    Sex,

    SSN;

SQL SELECT Address,

    AlarmCode,

    "Department_Name",

    DoorCode,

    FirstName,

    ImportantInformation,

    Information,

    KeyInformation,

    LastName,

    ProtectedIdentity,

    RoadDescription,

    Sex,

    SSN

FROM TriggerII.dbo."VIEW_KundUppgifter";

LOAD FirstName AS FirstName2,

    LastName AS Lastname2,

    Notes,

    Phone AS Phone2,

    RelationTypeText;

SQL SELECT FirstName,

    LastName,

    Notes,

    Phone,

    RelationTypeText

FROM TriggerII.dbo.viewPersonRelations;