How to produce the columns without adding dummy column in edited sql in Information Link

[Enkeled Kanaj]

Hi,

 

In the Information Link I have to do custom query where it can not produce the column without adding some dummy column which have to be in order corresponding to the order of the edited sql query.

Is any simple way to get the columns queried inside the edited script without adding this dummy column?

 

SELECT
    D1."DATE_ID" AS "DATE",
    D1."ERBS" AS "ERBS",
    D1."EUtranCellFDD" AS "EUTRANCELLFDD",
    SUM(CASE D1."DCVECTOR_INDEX" 
        WHEN 1 THEN D1."pmErabEstabSuccAddedQci" 
        ELSE 0 
    END) AS "pmErabEstabSuccAddedQci_1",
    SUM(CASE D1."DCVECTOR_INDEX" 
        WHEN 1 THEN D1."pmErabEstabSuccInitQci" 
        ELSE 0 
    END) AS "pmErabEstabSuccInitQci_1",
    SUM(CASE D1."DCVECTOR_INDEX" 
        WHEN 1 THEN D1."pmErabRelNormalEnbUserInactivityQci" 
        ELSE 0 
    END) AS "pmErabRelNormalEnbUserInactivityQci_1",
    SUM(CASE D1."DCVECTOR_INDEX" 
        WHEN 1 THEN D1."pmErabEstabAttInitQci" 
        ELSE 0 
    END) AS "pmErabEstabAttInitQci_1",
    SUM(CASE D1."DCVECTOR_INDEX" 
        WHEN 1 THEN D1."pmErabEstabAttAddedQci" 
        ELSE 0 
    END) AS "pmErabEstabAttAddedQci_1",
    SUM(CASE D1."DCVECTOR_INDEX" 
        WHEN 1 THEN D1."pmErabEstabAttAddedHoOngoingQci" 
        ELSE 0 
    END) AS "pmErabEstabAttAddedHoOngoingQci_1",
    SUM(CASE D1."DCVECTOR_INDEX" 
        WHEN 1 THEN D1."pmRrcConnReestSuccQci" 
        ELSE 0 
    END) AS "pmRrcConnReestSuccQci_1",
    SUM(CASE D1."DCVECTOR_INDEX" 
        WHEN 1 THEN D1."pmRrcConnReestAttQci" 
        ELSE 0 
    END) AS "pmRrcConnReestAttQci_1"
FROM 
    "DC_E_ERBS_EUTRANCELLFDD_V_RAW" D1
WHERE 
    <conditions>
GROUP BY
    D1."DATE_ID",
    D1."ERBS",
    D1."EUtranCellFDD";

[Olivier Keugue Tadaa]

Hi Enkeled;
Unlike the data connectors, the information links do not have that "Verify" button that generates the columns from SQL. statements.  By design, an information link needs columns  elements definition (as proper objects) to map to the SQL.
The purpose of manually editing SQL was not to reverse engineering to create the necessary column elements but to adapt the generated SQL. This is a paradigm change compared to what you know as "Fee-Hand" SQL in other platforms.

[Enkeled Kanaj]

Hi @Olivier Keugue Tadaa

So definitely there no way to get the name of column as defined in script (the red color name)?

SUM(CASE D1."DCVECTOR_INDEX" 
        WHEN 1 THEN D1."pmRrcConnReestAttQci" 
        ELSE 0 
    END) AS "pmRrcConnReestAttQci_1"

[Olivier Keugue Tadaa]

Yes, you can't do that with the information links..

I'd encourage you to use the data connectors where you will be able to have the expected behavior.

this article explains all the data access possibilities that Spotfire offers. 

 

Edited August 15 by Olivier Keugue Tadaa