Preeta
New Contributor II
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: Converting JSON to HTML Table for Email Snap
Hi, Using a similar scenario,but i don’t have a defined set of records to hardcode the table body . I can only hardcode the headers but will end up receiving multiple records. How can I address such a situation? @matt.bostrom @del Thanks, Preeta504Views0likes0CommentsSnaplogic Pipeline Metadata
Hi , I am trying to read the pipeline metadata, specifically the child pipeline names that are invoked from a particular pipeline . I used the Snaplogic Read snap and i have the information in the $snap_map object variable , inside which there are sub areas . But seems the $snap_map is defined for each area of the pipeline and i am not able to read the object property specifically for the ones with child pipelines. For example : $snap_map[‘06b13e42-5a86-4464-a0fb-7b682cbaddee’].property_map.settings.pipeline.value → gives me the name of the child pipeline invoked but i am not able to make it generic like $snap_map [ * ] .property_map.settings.pipeline.valueSolvedRe: How to refresh Tableau Extracts thru snaplogic
@skdarshanam : thank you . Can I refresh one particular workbook using this ? If yes then what should be the inputs ? Is siteId and taskId the only input needed? I have set up the tableau account and also selected the “run_extract_refresh_task” . It returns the below error : “reason”: “REST API service endpoint returned error result: status code = 500, reason phrase = Internal Server Error, refer to the error_entity field in the error view document for more details” “resolution”: “Please check the values of Snap properties.”3.1KViews0likes1CommentRe: Can We create a Variable in Mapper
Hello, I used the above functionality to implement RANK also.I am trying to implement the RANK function similar to what we have in sql. Rows with equal values for the ranking criteria should have the same ranks and ranks might not be consecutive numbers. For example, if two rows are ranked 1, the next rank is 3. I have got the code but its too many snaps and i want to simplify it. Here is the pipeline and output: SampleRankJob_2019_09_24 (2).slp (23.5 KB) key name date rank ABC Orange 8/1/2018 1 ABC Orange 10/1/2018 7 GEF Apple 10/1/2018 1 GEF Apple 11/1/2018 31.2KViews0likes0CommentsImplementing RANK function
Hello, I am trying to implement the RANK function similar to what we have in sql. Rows with equal values for the ranking criteria should have the same ranks and ranks might not be consecutive numbers. For example, if two rows are ranked 1, the next rank is 3. Here is the output I am expecting , I have attached the input pipeline. i have got the consecutive ranks but not able to figure out how to eliminate the ones which are same. key name date rank ABC Orange 8/1/2018 1 ABC Orange 10/1/2018 7 GEF Apple 10/1/2018 1 GEF Apple 11/1/2018 3 SampleRankJob_2019_09_24.slp (13.8 KB) Thanks , Preeta3.2KViews0likes2CommentsRe: Can We create a Variable in Mapper
Hi Tim, Thank you for your reply. Even if I concatenate , the issue here would be that it would generate a cumulative sum for all the records while I want to get the cumulative sum grouped by each product. In the above solution , the ruuid is same for all the records while i need a new ruuid for each group of same product records. Hope that makes sense. Thanks , Preeta2KViews0likes1CommentRe: Can We create a Variable in Mapper
Thank you responding . Here is the input and expected output count Date product 2 2008-01-31 ABC 1 2008-07-31 ABC 2 2009-01-31 ABC 1 2009-04-30 ABC 3 2009-07-31 ABC 3 2009-10-31 GEF 5 2010-01-31 GEF 1 2010-04-30 GEF 3 2010-07-31 GEF output : Sum Date product 2 2008-01-31 ABC 3 2008-07-31 ABC 5 2009-01-31 ABC 6 2009-04-30 ABC 9 2009-07-31 ABC 3 2009-10-31 GEF 8 2010-01-31 GEF 9 2010-04-30 GEF 12 2010-07-31 GEF2KViews0likes1CommentRe: Can We create a Variable in Mapper
Hello @Anil , I am trying to implement similar logic but i need to group by two fields instead of one unlike in the above example. Instead of only emp_id , I have two fields i need to consider, suppose product_name and product_date , and then find the cumulative sum for this combo . Can you please help me with the logic for this?2.7KViews0likes2Comments