Change multiple fields with Empty Value

0

It looks like you are misusing this action.

In Attribute mappings
* column 'Field' - it's a field on form which should change value
* column 'Column' - it's a value based on SQL.

Right now you are selecting values with query, and setting them all to the same field called 'Clean Field'.

So based on your screenshot i'd say it should look like this:

Query: SELECT '' As Empty (note: I'm not sure what value should be used here, as empty string might not work, and i'm not sure if 'Empty' means NULL in db)

Field:
* Bank
* Issue Date
* Guarantee Expiration Date
* Counter-Guarantee Expiration Date
* Collateral Duration
* Collateral Counter Validity

Column:
* Empty
* Empty
* Empty
* Empty
* Empty
* Empty

Hi! Thank you for the answer, I've tried your idea but I'm getting an error. I cannot save it using empty, null or ''
I can do this with the action single change but I have a lot of fields in 2 other similar actions.

Hi Andreia,

did you use a statement similar to this?
select null as Empty

I'm not sure whether you can map the same column multiple times. If this is not possible, you can just number the columns.

Best regards,
Daniel

Thanks a lot Daniel!
It worked as you proposed and Webcon did not complain using it multiple times in the column source!

Thanks!