cancel
Showing results for 
Search instead for 
Did you mean: 

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

thomas_bayer
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

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

former_member308471
Participant
0 Kudos

Hi Richard,

Can you guide on which type of Node supports this feature and under which section should we write the expressions?

Please help with few steps or screenshots for the same.

https://answers.sap.com/questions/85809/how-to-concatenate-multiple-columns-using-hana-flo.html

Regards,

Kiran

Hi Thomas, Hi Kiran

you can use the mentioned SQL using the mapping expressions in the Filter Transform. I've attached a screenshot on how this exactly works to the referenced question submitted by Kiran.

Best Regards,

Timo Wagner

former_member308471
Participant
0 Kudos

Thankyou so much Timo. I have tried this and it worked!!!

I have one more design problem with flowgraph. Kindly help me with the same.

https://answers.sap.com/questions/90507/how-to-remove-extra-columns-of-target-in-flowgarph.html

Regards,

Kiran