former_member451049
Explorer
Member since ‎05-24-2017

User Statistics

  • 12 Posts
  • 1 Solutions
  • 1 Kudos given
  • 1 Kudos received

User Activity

Date issue in Data services

06-07-2019
We are getting the input data as 01/01/2019,01.01.2019 and 20190101 we need to convert all this date types in to YYYYMMDD in SAP BODS Please share your suggestions, Thanks, kishore

Number is not increasing with Gen_row_num_by_group function

09-12-2018
Hi all, I am using gen_row_num_group_by function(Data services) with account id and its relation type. When we have same data with account and relation it needs to increase the key value. Syntax used :gen_row_num_by_group(accountid,relation...

how to concatenate the input column with comment in if then else statement in a query transform

09-13-2017
Hi I want to validate and provide the comment and at the same time i need to concatenate the input data as well how to provide the third parameter with comment and input field EX : ifthenelse((country='ind'),'Green',' comment||input_field') Th...

SQL transform issue in data services

07-24-2017
Hi Folks, I am using SQL transform in data services, Here when i am using the query in hana getting complete records. The same query i kept in sql transform and loading in stg table without any filters. But few records are missing when loading in s...

unable to update the schema with SQL transform in Data Services 4.2

05-24-2017
Hi All,I implemented one complex query it includes joins,cast ,replace and few more filter conditions. the same query i am able to execute from hana data base.When i am trying to use with SQL transform in Data services schema is not updating and i a...
Kudos from
Kudos given to