Data Updation based on a Category

[Jebin97]

Hi There,

I want to update a group of values based on a category but not on the primary key.

Consider I have a dataset with 50 rows and the data is categorized into 5 groups, While inserting the data into the DB it should check whether there is data related to the inserted category, if yes then the data related to that category should be dropped and new set of values should be inserted.

How should I write a logic for this.

Input & Output DB: Snowflake

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[Anonymous]

@Jebin Atheesh P L​ , you meant all the existing data related to that category in DB will be dropped? and then insert new set of values?

Regards

Shong