SQL - removing data

Question

Hi all,&nbsp;I have this SQL shown below. Only problem is that there is a problem with 2 of the days with 2 specific style.&nbsp;Is there a way to remove style numbers 12170151 and 12138940 for the days 23-12-2019 and 24-12-2019?&nbsp;SELECT TTL_CALC_COST,STOCK_AGE,COLLECTION_NAME,COLLECTION_TERM,STOCK_DATE,STOCK_COUNTRY_NAME,QUANTITY_TYPE,WAREHOUSE_NAME,SUPPLY,ASSRTMNT_TYPE_NAME,QUANTITY,TTL_WHS_EUR,BRAND_NAME,STYLES_ID,SALES_TYPE,COUNTRY_CMP,STYLE_CATEGORY_NAME,STYLE_SUBCATEGORY_NAME,STYLE_TYPE,STYLE_NUMBER,STYLE_NAME,COLLECTIONS_ID,ASSORTMENTS_ID,ASSORTMENT_NAME,CUSTOMER_GROUPS_ID,GROUP_NAME,SUBDEPARTMENT_IDFROM DISCOVER.DISC_STOCKWhere SUBDEPARTMENT_ID = '21'

anonymous · Answer

Create measure&nbsp;New measure=if(max(Table[datecolumn]) in {"23-12-2019","24-12-2019"} &amp;&amp; table[style Number] in {12170151,12138940},1,-1)&nbsp;then add this measure to visual level filter and set it to 1.&nbsp;Thanks &amp; regards,Pravin Wattamwarwww.linkedin.com/in/pravin-p-wattamwarIf I resolve your problem Mark it as a solution and give kudos.

imlaug · Answer

Hi Pravin Wattamwar,&nbsp;Thank you for your response, however the struggle isnt to create a measure or an extra column, but to do it via the SQL.&nbsp;The issue is that i would prefer to have it removed via the SQL, as the SQL is used multiple places.By doing that i can avoid having to create a measure in every report.

anonymous · Answer

So you need SQL of this?&nbsp;simply update where clause&nbsp;where style_number not in (Value1,value2)and date not in ("value1","value2")&nbsp;Thanks &amp; regards,Pravin Wattamwarwww.linkedin.com/in/pravin-p-wattamwarIf I resolve your problem Mark it as a solution and give kudos.&nbsp;

imlaug · Answer

But wouldnt that remove the 2 days completely?&nbsp;I only need to remove the figures for those 2 styles on those 2 days. i still want all other data from those 2 days.&nbsp;Does it make sense?

anonymous · Answer

then simply create cte;with cte as(Select&nbsp;Case when style_number in (value1,value2) and date in&nbsp;(value1,value2) then null else&nbsp;style_number end as [style number]from table)&nbsp;select * from cte where&nbsp;[style number] is not null&nbsp;&nbsp;&nbsp;&nbsp;Thanks &amp; regards,Pravin Wattamwarwww.linkedin.com/in/pravin-p-wattamwarIf I resolve your problem Mark it as a solution and give kudos.

Forum Discussion

SQL - removing data

8 Replies

Related content

Creating date slicer removes data

remove duplicate value within a row

Removing Duplicates

Stream On-Prem SQL Server Data

Adding Legend Removes Data Labels