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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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;