pass

[Anonymous]

Hi team,

I am in a need of solution.

[jonathandienst]

I think this is what you need:

OracleData:

Concatenate SQLData:

LOAD DateOracle                    AS Date,

     StringOracle                  AS String,

     PACOracle                     AS PAC,

     Cost_Oracle                   AS Cost,

     Year(DateOracle) & Month(DateOracle)  & StringOracle &  PACOracle AS  Key

FROM ..\Link.xlsx]

(ooxml, embedded labels, table is Oracle)

Where not Exists(SQLKey, Year(DateOracle) & Month(DateOracle)  & StringOracle &  PACOracle);