About malinisomu

malinisomu · 09-07-2023

Dear friends, I have excel sheet values as below 47f5194f-5c5c-4fa4-a1b8-83eae6e52dab.jpeg I need to find anyone of this value exist in MARA table and the field name is EXTWG ce07a500-478b-4c6e-a881-49fecb6c170e.jpeg if exist i need to say ...

malinisomu · 07-06-2023

Hi , I need to search a string value inside another string and if its exist i have to have a column with the value 'YES' or 'No' in the below example I have to search UNSPSC_DESCRIPTION1 in COMMPODITY ASSIGNMENTS Since there is no built in f...

malinisomu · 05-10-2023

Hi, Can anyone help me with the nested Json file? I am extracting data from Windchill system and the file is in JSON format.I like to get only Source,Number and Short_Description in the output.{ "source":"HI", "incidents":[ { "number":"INC0000001",...

malinisomu · 03-02-2023

Hi , I want the source file to be moved to the Archive folder after the processing/Loading. The below highlighted in YELLOW command moves but without any time stamp. Please let me know the syntax for moving file along with time stamp....

malinisomu · 02-10-2023

Hi, I want to calculate the running sum of certain column values in BODS/SAP Data Services. As mentioned in the below example LRP value needs to be sum up for each row(Running_Sum_LRP) and the group by LOB.Can anyone help me with custom function ...

malinisomu · 07-29-2023

joseph_muiruri Thank you very much for your elaborate answer. It works. Thanks,Malini

malinisomu · 05-11-2023

Thank you akhileshkiran

malinisomu · 04-13-2023

Hi , I am new to SAP HANA Calculation view and I modified the design a bit and this is also working. Table TAB1 has three columns as mentioned below, 2) Load the same table in two different Projections Projection_1 and Projection_2 3) Do inn...

malinisomu · 03-24-2023

shaheen.makandar I had the similar requirement in SAP Information Steward project and your blog helped me.Thanks. BEGIN # define validation rule expression RETURN match_regex($parameter0, '.*MECHANICAL.*','CASE_INSENSITIVE') END

malinisomu · 03-21-2023

avmrams How do I know that the stored procedure result is going to be reside inside this table TBL_OPP_STAGE_CHI..(as per your example) Do we get this information(table name) from the owner of the Stored procedure? Please let me know. Thanks, Ma...

User Statistics

User Activity

Custom Function to lookup anyone value in MARA - SAP BODS

Find a String inside another string in BODS /SAP Data services

Nested JSON file in BODS

Unix command in BODS to move file from one folder to another Folder

Calculate Running Sum in BODS/SAP Data services

Re: Find a String inside another string in BODS /SAP Data services

Re: Nested JSON file in BODS

Re: Cumulative Sum / Running Total in HANA Calculation View

Re: Using match_regex function to replace "LIKE" function in Information Steward Rules

Re: Execute Stored Procedure from BODS and then start data extraction from SQL Table