Check column data null or not

[korhansuren (Korhan Süren)]

Hello,

I want to check if there is data in a4 in the data. For example, there is currently Turkey data. When there is data, the process will continue, when there is no data, it will give a “data not found” warning and stop. I tried the read cell activity, but I got an error while converting numeric data to string. How can I do this in the easiest way?

Thank you so much!

[mahmoud.zaky]

@korhansuren

I want to check if there is data in a4 in the data. For example, there is currently Turkey data. When there is data, the process will continue, when there is no data, it will give a “data not found” warning and stop. I tried the read cell activity, but I got an error while converting numeric data to string. How can I do this in the easiest way?

Hi @korhansuren
can you please update us with your activity or your workflow to validate it however you can use read range and make your range start with (A4:D4) and then validate if the extracted data table rows = 0 if this so its rempty if > 0 so sheet has data and you can continue your script. please check and update us

[pavan_kumar5 (pavan kumar)]

can you post the error scrrrn shot

Regards,
Pavan kumar

[Sverre_Klein]

Hi Korhan,

If I understood you correctly, you have trouble to check if your A4 cell is null or not.

You can use the output of your read cell activity and then check with an if statement if it is empty or not.

Try to use String.isnullorempty(yourcelloutput)