November 18, 2013, 05:04 PM
dr.herojos[CASE-CLOSED] (FOC14010) NOT A VALID COLUMN NAME: LIVELLO_ESCALATION
Hi, this my first post in this community, but i've used it frequently. First of all i want to apologize for my bad english and i hope that i'm clear to explain this issue.I've this problem: In my workspace i use a UNION statement.
I've upload 2 file (excel file) , create 2 synonym and adjust the format if necessary.
I connect to SQL statements and then to the UNION. After UNION i've a JOIN with the other table SQLServer and xfocus format.
When i choose a filed of union select to write in a table target i get this error: (FOC14010) NOT A VALID COLUMN NAME: LIVELLO_ESCALATION.
I'm newbi but seems that if i want federate more data type specially xfocus the dataflow doesn't work if is a presente UNION.
If i remove xfocus and, in Last SQL statement, i put an alias on LIVELLO_ESCALATION filed , than tha dataflow work pretty well.
What's wrong? this is the prepare code:
-TYPE (ICM18429) Issuing PREPARE
SQL PREPARE SQLIN FROM
SELECT
T7.IST ,
T7.NDG ,
T7.E_ACC_CASSA ,
T1.LIVELLO_ESCALATION AS LIVX
FROM
((SELECT
T8.ISTITUTO ,
T8.SAE ,
T8.SETTORE ,
T8.DESCRIZIONE_SAE
FROM
dm_sae T8
) T9
RIGHT OUTER JOIN
((SELECT
T6.IST ,
T6.NDG ,
T6.E_ACC_CASSA
FROM
vr00s001_30092013 T6
) T7
LEFT OUTER JOIN
((SELECT
47 AS ISTITUTO ,
T4.NDG ,
T4.LIVELLO_ESCALATION ,
T4.M_NDG
FROM
bari T4
) --T2
UNION
(SELECT
46 AS ISTITUTO ,
T5.NDG ,
T5.LIVELLO_ESCALATION ,
T5.M_NDG
FROM
cro T5
) --T3
) T1
ON
T7.IST = T1.ISTITUTO AND
T7.NDG = T1.M_NDG )
ON
T9.ISTITUTO = T7.IST )
END
-RUN I'm doing something wrong? Thanks for the answers
This message has been edited. Last edited by: dr.herojos,