jrtomici Member

@GrantSmith thank you. Unfortunately the dataset is far too large and has far too many different numbers listed in that column to use the split function.

@ST_-Superman-_ that's a really smart solution thanks. But unfortunately yeah, my initial thought process wouldn't work in this problem because of the example I depicted in ID #2. I only need one row from that grouping.

Time is in this format 07:32:39 You brought up a good point and I need to rethink the problem. I have a dataset that looks like this: ID Time 1 07:32:39 1 07:32:40 1 07:32:41 1 07:32:41 1 07:32:42  1 14:46:59 1 14:47:00 1 14:47:01  2 01:04:29 2 01:04:30 2 01:04:31 2 01:04:31 I need only one from each section/time range.…

Thank you so much!

Great, thank you. How would I approach the logic of removing duplicates only within a unique ID? I don't want to remove all duplicates, just `Num`s that appear multiple times within a corresponding ID (see example). @RobSomers thanks!

@GrantSmith I got it now. Thanks for the concise explanation!

@GrantSmith Ok, this has been great help and I understand the logic. I did all the steps but I'm hung up on the end, how do I find the sum?

@GrantSmith Hi, thanks for the in depth answer. Could you elaborate on what you mean by a Calendar data set? Also maybe could you provide a pseudo ETL to help me visualize the dataflow?

@huanlin Sorry--my table's first column is just the name of the row in the original data. It's the column whose duplicates I want removed, and to do this, I sorted by the COUNT of that column.

@huanlin In the analyzer I sorted by the first column and that worked for me.

@MarkSnodgrass follow up question: I have two cards now, each checkbox filters that filter by the new columns made in Magic ETL since both these columns can have multiple values. However, when one of these filters is used, all the checkbox options in the other filter card disappear. How can I allow both filter cards to be…

That makes a lot of sense, thank you so much. Only issue is now, if multiple filters are selected, there can be repeat rows in the table. So if the user wants a table that displays only rows that support desktop or mobile, if both those filters are selected, any row that has both desktop and mobile will now appear twice.…

Thanks for the response Mark. This filter would need to be a card used for salespeople to filter the table and create customized tables. Say a client wanted to know which packages (rows) support mobile devices. The salesperson would use the checkbox selector card to select "Mobile" and the table would display only relevant…

Hi Mark, Thanks for the answer. This card is part of a dashboard that will be accessed by various salespersons. These salespersons are not familiar with SQL and need an intuitive interface for filtering the data. The list of zip codes is not static either, the list will change depending on who is using the dashboard and…