How to SELECT a column twice from the same table in sql to show different value?

Question

I want to show different value in Qlik sense dashboard, but I have to use same column from same table in SQL - how can I do this?

Here is my code: "first"

LOAD WORKORDERID As ID,
    REQUESTERID as RqId,
    TITLE As Subject,
SQL SELECT WORKORDERID,
    REQUESTERID,
    TITLE,
FROM servicedesk.dbo.WorkOrder;

LOAD WORKORDERID As ID,
    CATEGORYID,
    SUBCATEGORYID As SID,
    OWNERID as TechID,
    ASSIGNEDTIME,
    REQUESTTYPEID;
SQL SELECT WORKORDERID,
    CATEGORYID,
    SUBCATEGORYID,
    OWNERID,
    ASSIGNEDTIME,
    REQUESTTYPEID
FROM servicedesk.dbo.WorkOrderStates;

now i want to show my queue name and want to use workorderID again :

LOAD QUEUEID As QID,
     QUEUENAME;
SQL SELECT QUEUEID,
    QUEUENAME
FROM servicedesk.dbo.QueueDefinition;

LOAD WORKORDERID;
SQL SELECT WORKORDERID
FROM servicedesk.dbo.WorkOrder;

LOAD WORKORDERID,
    QUEUEID ;
SQL SELECT WORKORDERID,
    QUEUEID
FROM servicedesk.dbo."WorkOrder_Queue";

Welcome to SO! Please don't post code as pictures - [edit] your question and paste the code as text (properly formatted) instead. — Frank Schmitt, Dec 10 '17 at 08:17
Please do not post images (links of) code - cannot cut 'n' paste them! — Ed Heal, Dec 10 '17 at 08:17

score 1 · Answer 1 · answered Dec 10 '17 at 08:19

1

Assuming you just want to display the value from a single column twice in the same query, you can use SQL Aliases.

SELECT
    column_name,
    column_name AS `column_name_2`
FROM table;

answered Dec 10 '17 at 08:19

melonlogic

21
2

No i know aliases as well but i think i should create a new table , i edit my question so you can read it again, thanks – Pooneh.T Dec 10 '17 at 08:48
Please clarify what you're trying to achieve here, what should your ultimate query look like? – melonlogic Dec 10 '17 at 20:33

score 0 · Answer 2 · answered Dec 27 '17 at 04:47

Have you tried using ‘NoConcatenate’?

Ex: LIB CONNECT TO 'QV_table'; LOAD aa, bb, cc; SQL SELECT aa, bb, cc FROM ADWorks.dba.'table1';

LIB CONNECT TO 'QV_table'; NoConcatenate LOAD aa AS AAT1, ee, ff; SQL SELECT aa, ee, ff FROM ADWorks.dba.'table1';

How to SELECT a column twice from the same table in sql to show different value?

2 Answers2