Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Deleting value

Avatar

Avatar
Validate 1
Level 1
associationp157
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
associationp157
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
associationp157
Level 1

14-12-2017

Hi

I need to do something that should be easy: deleting information from the table (I'm deleting adress information that is no longer accurate).

However, I can't seem to do it.

I'm using a data update component and for each field that need to be deleted, I'm setting the source to ''. At runtime, this ends with a sql error.

Does anyone know what should be the proper process to delete the value of a field ?

Thanks for your help

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

352 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

352 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Jean-Serge_Biro
MVP

14-12-2017

Hello,

It is more probably a question of integrity constraint, or value type mismatch.
In SQL queries you can use NULL values; if you want to do it with Update activity, please check the Advanced parameters checkbox. And please share the exact SQL error

Regards

J-Serge

Answers (6)

Answers (6)

Avatar

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
RamaRajesh
Employee

14-12-2017

Hi,

Please try the below sql. Modify the sql with your table name and column name. All the values of the given column in the table will be deleted.

1372935_pastedImage_0.png

Thanks,

Rajesh

Avatar

Avatar
Validate 1
Level 1
associationp157
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
associationp157
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
associationp157
Level 1

15-12-2017

Hi Jean-Serge

Thanks for your inputs, they helped me solved my problème.

My 2 mistakes were the following:

- updating a value with the '' string (empty string) does not work (the value is not erased)

- when using the NULL value, you canot just enter NULL in the list of field to be updated. You need to click on "Edit the source expression", then enter NULL and validate.

Avatar

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
RamaRajesh
Employee

14-12-2017

I know the sql way of doing it. Sorry, I am not aware of any other way.

Avatar

Avatar
Validate 1
Level 1
associationp157
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
associationp157
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
associationp157
Level 1

14-12-2017

I was looking for a non-sql solution, to keep the workflow easy to understand for people with less database skills.

Or does this mean it is not possible delete some values using the Update data component ?

Avatar

Avatar
Validate 1
Level 1
associationp157
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
associationp157
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
associationp157
Level 1

14-12-2017

Yes, I'm doing the "Update" operation because I need to keep the record and just delete some of its value

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

14-12-2017

Hi,

What operation are you performing with the update data activity?

There is a dedicated "delete" operation in this activity which can be used. From what you described, I understood that you are using the "Update" operation.

Florent