This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
What does true() do when setting the alter row transformation to :
delete if --> true()
upsert if --> true()
Thank you
An Azure service for ingesting, preparing, and transforming data at scale.
Those rules will result in every row being deleted from your destination table that matches the key columns you set in your sink
The key columns are:
field1, field2 field3
For upsertif I should put true()
For deleteif I should put:
iif(not isnull(field1) and iif(not isnull(field2) and iif(not isnull(field3)
Am I right?
Thankyou
Answer accepted by question author
That rule will upsert all rows and will only delete rows that have a value in field1, field2 and field3. The actual syntax would look like this:
!isNull(field1) && !isNull(field2) && !isNull(field3)
Do you actually mean it will delete IF there is NO value in those fields?
The syntax I put above will set rows for delete if field1, field2, field3 are NOT NULL, which means that they have a value
So if I would like to delete when the field1 is empty then it should be:
deleteif --> isNull(field1)
?
Thank you
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
@arkiboys : That should work .