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,

Hello dr.herojos,

Please open a case on InfoResponse Online so that we can look into this issue further.

Thanks and regards,

Kathryn

Status/Action: NCUM/RNTS
Support Group: RESEDA Rep: LAWRENCE CIVELLI (LCC)
Severity: 3 - Application Issue

Hi,
this issue will be fixed in 7706.

Regards,
Larry