save output if columns have value

Question

Hi I have a dataset and I have to save it only if it has value and if the data is not there then I should not overwrite the old data

Example:

Scenario 1.

In the below condition we should overwrite yesterdays file because it has value

nameplacecityjamesUKlondonClarkUSANY

Scenario 2.

2nd a scenario where all the columns are empty, here I should not overwrite it

nameplacecity

Scenario 3.

3rd scenario everything is null, here I should not overwrite it

Note: In Scenario 2 and scenario 3 I should get an error message and stop the canvas

mceleavey · Answer

@Sshasnk ,

Use the Message tool and the Count Records tool.

This will give a count of records present. Simply attach this to the Message tool and configure as follows:

This will throw an error and tell you there are no records present.

Hope this helps,

M.

patrick_mcauliffe · Answer

Can you post your workflow?  I must not be understanding your description.

Sshasnk · Answer

it will still overwrite and you will get empty values in your column