November 18, 2013, 05:04 PMdr.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
T1.LIVELLO_ESCALATION AS LIVX
RIGHT OUTER JOIN
LEFT OUTER JOIN
47 AS ISTITUTO ,
46 AS ISTITUTO ,
T7.IST = T1.ISTITUTO AND
T7.NDG = T1.M_NDG )
T9.ISTITUTO = T7.IST )
I'm doing something wrong? Thanks for the answers This message has been edited. Last edited by: dr.herojos,
November 20, 2013, 07:39 PM<Kathryn Henning>
Please open a case on InfoResponse Online
so that we can look into this issue further.
Thanks and regards,
March 04, 2014, 05:26 AMdr.herojos
Support Group: RESEDA Rep: LAWRENCE CIVELLI (LCC)
Severity: 3 - Application Issue
this issue will be fixed in 7706.