-
How to write a function that returns positive if function contains values from another column?
The title is a little confusing, but basically I want to write a function like this: CASE WHEN `Track Split` LIKE '%AZ%' THEN 'AZ' end EXCEPT, instead of basing it off of a string, I want it to pull values from another column. I have a lot of changing data from row to row, so I want the row to check to see if the data…
-
Set values in a column based on a "master row"?
We are a music library company that makes a large amount of our income from the sum of tons of small royalties. Pretty much the only information that comes in from the royalty reports is the track title and amount earned, and even if it does have other information it's not unified among all the different royalty sources…
-
Can I make a "mother row" to assign values from?
We are a music library company, and as such a large amount of our income comes in as small royalty payments that add up incrementally. The information comes from 15+ different collection sources, and in general the only thing consistent between them all is the track title. That means that the information from the royalty…
-
Why is my card missing rows?
I have a card that only has 11,517 rows but the dataset feeding into it has 12,999. So somewhere between the dataset and the card, it's filtering out 1,400 rows. I don't have any filters in place, all I'm doing is specifying the columns that need to be added, and all of the columns that I've specified include data for the…