on 10-25-2016 9:28 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.