Hi all I have a table of 1,000+ people. Each person = one row. One of the columns shows the companies they have worked for in the past (e.g. 'BT, Shell, Facebook'.) You know what's coming…. I would like to be able to give my dashboard a filter that shows each company once and brings back any person/row that CONTAINS that…
Hi Dojo, We have several datasets that are appending a decent amount of data each day, and we do not have a need to keep data from as far back as our datasets are holding. Does anyone know of a solution that makes connectors work with a "moving window" to only hold relevant data? ETL solutions work well for our datasets…
Hi All, I am working to combine two tables. The first step I need to take is to filter the project_number by with the newest report date available. The example below shows two different project numbers The first one has the last report date as Q3 2022 - we need to capture that input The second project_number has q4 of 2022…
I have two datasets, same structure/columns, 1 large dataset with all records and another large dataset with suspected duplicate customers removed. I want to join these together and create a flag for the suspected duplicate records. I tried to add a formula tile to each dataset, Duplicate = Yes ( for dataset filtered dupes…
I have data this way: Account | Category | Date 12 | Phone | 01/01/22 12 | TV | 01/01/22 13 | Phone | 01/02/22 12 | TV | 01/01/22 I would like to figure out on each date the counts for each subcategory. First i would want the data pivoted this way: Account | Category | Date 12 | Phone, TV | 01/01/22 13 | Phone | 01/02/22…
Hello, I am using Magic ETL and trying to convert a text field to a date field. Earlier on my data flow I had to alter some columns by using the cast function. I was able to continue with the data flow and have the output I want. It was until I was creating a card that I noticed the "Date" is "Text". (I have some formulas…
Why does this error occur? Normally it isn't that big of a deal, but I just spent the last 10 mins creating color rules and now I am going to lose all of them and have to start all over…
Does anyone know how to create a Regex that only accepts a segment with a number before a 'k' and nothing after? Or it can be a regex that replaces everything that doesn't have a number before 'k' and nothing after with an empty string. I am looking to extract the circ value for our email campaigns but some rows have a…
I am trying to import some old Data and merge it with data from a connector but the data is in different orders. The legacy data went decending 1 2 3 4 but when I merge the data with the connector its adding to the top so I get 5 1 2 3 4 I was just wondering, is it possible to merge the data onto the bottom or sort the…
Hello, I have two data sets, that I ma trying to combine, And After I combine the sets, I get dupplicates Any reccomendations?
It looks like you're new here. Sign in or register to get started.