Skip to Content

Hana smart data accsess: How to transform as in SAP BW

Hello,

I have a seemingly trivial problem, i.e., within SAP BW it is very easy to solve. I want to transfor a table with contains three columns for the date (year, month, day, all integers) to the sql-date type. Unfortunately, I do not see a solution within a flowgraph on hana.

Has anyone a useful hint?

Thomas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 11, 2016 at 04:28 AM

    Hi Thomas,

    You should be able to use the TO_NVARCHAR, CONCAT and TO_DATE SQL functions in the Filter transform in the Flowgraph to do this.

    Richard

    Add comment
    10|10000 characters needed characters exceeded