-
Re: Converting OSGB36 coordinates (Eastings and Northings) to WGS84 Lat Longs?
Hi, At the recipe level, in the advanced settings, you can also specify which code environment to use for that recipe alone. See the attached image. I hope this helps.1 · -
Re: How to avoid duplicates while merging daily billing data to monthly billing data
Hi, To remove the duplicate data, you can use the Group recipe, indicating the unique keys and deciding the aggregations for the other columns (first value, max value, etc.). Here is a video describe…2 · -
Re: How to capture exception results in seperate table if the business rules fails during data ingestion
Hi, I suggest you approach your challenge as data preparation logic: * In a Prepare recipe, create new columns to indicate the failure of each condition separately; * Create a summary column that mar…1 · -
Re: How to extract the records in latest process date?
Hi, You should explore the concept of Partitioning, which allows you to run your flow just for a chunk of data. For example, in an SQL dataset, you can just process the last available date of a speci…2 · -
Re: Dashboard>> Charts>>Tables
Hi, Not on the chart itself. What you can do is use a Group or Pivot recipe, creating the key with all the columns you need, and then expose the resulting table in the dashboard. I hope this helps1 ·