pranil2k2
Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: Get minimum date from set of column values
Hi bojanvelevski, Thanks for the reply. I too tried Group by N snap but i forget as we can read the columns using index path. Now to get my output i need to do group by on some column, but now we dont have any column to do, i tried using Aggregate snap as i cant group by i got only date output but i need file name too. any advice here. The output should be as below. Thanks Thanks2.8KViews0likes1CommentGet minimum date from set of column values
Hi, I have a typical requirement, where i need to find the Min ETL run time from below set of data. I tried to convert rows into columns but there is no common field to do group by. i tried different options but nothing worked for me The desired output is like report name and time Please some one can advice here. ThanksSolved3.1KViews0likes3CommentsRe: IF else Condition in Mapper
Thanks for the reply, i am not getting correct example on match that uses multiple columns. please can you share me some example and also in mapper if i use match, it is giving error. please can you share me some example on match that use multiple columns. Thanks again9.5KViews0likes0CommentsIF else Condition in Mapper
Hi , I have a requirement to write multiple IF/ELSE conditions and generate an output column. but i am getting syntax error, please someone correct me $section == “Presentation” && $action_field == “Product Short Name” ? $EMA_PRODUCTSHORTNAME: $section == “Presentation” && $action_field == “Product INN/Common Name” ? $EMA_PRODUCTGENERICNAME: $section == “Presentation” && $action_field == “Product Strength Name” ? $EMA_PRODUCTSTRENGTH: $section == “Presentation” && $action_field == “Full Presentation Name” ? $EMA_PRODUCTNAME: $section == “Presentation” && $action_field == “Product Form Name” ? $EMA_PRODUCTFORM: $section == “Authorisation” && $action_field == “Orphan Drug” ? $ORPHANDRUG: $section == “Authorisation” && $action_field == “Authorisation Number” ? $EMA_AUTHORISATIONNUMBER: $section == “Presentation” && $action_field == “Product Company Name” ? $EMA_PRODUCTCOMPANYNAME: null ThannksSolved17KViews0likes6CommentsRe: JSON Splitter for an Split column
i can provide the pipeline but the sample files may be data privacy issue. EMA_Load_XML_Data_to_Table_2021_03_29.slp (16.5 KB) as i explained, i have XML files, in XML we have a x column which need to split on /n (new line character), which i did it in mapper using split function. by default the output of split function is an Array (i also used sl.ensurearray function) and then i passed the column to JSON splitter. The splitter has to split array elements, but for multiple files the splitting is not happening as excepted. sorry, i cant share files is any other way i can share the screen?1.5KViews0likes0CommentsRe: JSON Splitter for an Split column
Hi, Ok, the data before JSON splitter… it has two rows row1, row 2 The excepted output should be atleast more than one row in out put for two rows, but i am getting only one document as output for one of the xml the excepted output is other columns also like version number,etc. other xml is splitting as excepted. As said earlier i didn’t find any issue if i execute pipeline for single files… i know as per logic it has to work because it is an array but i don’t know why it not splitting as excepted when i am trying to execute with multiple files…2KViews0likes0Comments