I have the following query:
SELECT
item_code,
description_global,
dept_item || class1_item AS division,
view_year_code AS year,
ssn AS season
FROM
us_raw.l_ims_sum_code_master
WHERE
ssn IN (3,4)
AND view_year_code = 9
AND description_global IS NOT NULL
AND item_code = 418251
Here's what it looks like in the output:
I only want my data to pull with one of those description_global values. I know I can just do LIMIT 1, but I need another way to do it because this is just one example, and I want my output to force only 1 row for each time there are multiple description_global values.
Thank you, Z
I was able to resolve this issue by using an Index in Tableau. Here are the steps for anyone that is using SQL+Tableau:
1.) Create a calculated field
2.) Simply enter Index()
3.) Click OK
4.) Drag the newly created field into your rows
5.) Right-click on the Index pill (whatever you had named it) and click compute on
6.) Select whichever field that has multiple values (item description for me)
7.) Right-click again and click filter
8.) Filter to only show 1s
9.) Remove from rows (if you don't want it on your report)
10.) Done
Best, Z