Skip to Content
0

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

Oct 25, 2016 at 08:28 PM

66

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Richard LeBlanc
Nov 11, 2016 at 04:28 AM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

1

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

0