Robust Transform skip empty field

[Fredo]

Hi

I am working with RTE and I have a source table like so

 | Source Field1 | Source Field2 | Source Field 3 | Source Field 4 |

The are a certain times that one of the Source Field is empty. I would like to ignore that empty field and copy the data of the rest of the source field to their corresponding target field. 

Apart from turning off the below option

Is there away of skipping that empty source field by using a Robust Transform Operation?

Many thanks in advance

[KevinBellardine]

Hey @Fredo

The challenge you're going to have is that you're trying to do this at the field level. You could check in an On Before script if you didn't want the row to create at all, but if you're looking for the data and just don't want empty fields the only way to do it is to use the checkbox.

There might be a workaround. You could use a multi-input operation, pass it the field you're checking as well as the key(s) you're using for coalescing, and check to see if the field you're mapping is empty or null. If it is, you could run a gliderecord query using the other inputs, grab the value, and output that. This isn't a great idea from a performance perspective, but if you have no other way around it then it should work.

[Fredo]

Thank you @KevinBellardine ...

Question again

What if I have the situation in which in the target field has already data and I dont want to wipe out because the source field is empty?

Any ideas?

[KevinBellardine · Accepted solution]

That was kind of what I was getting at. The only way I can think of is to query the target record in the actual table you're mapping to and set that to your output.