Checking for blank rows in my table when working with for each Row

Help Studio
, ,
1

Hi,
I am reading from an Excel sheet using for each row, and wished to improve my configuration to ignore blank rows in my Excel sheet:

My question relates to the hierarchy of my workflow?!

I wish to read data from a file, write data to a data table (evaluating any blank rows and ignore them), then (for testing) write to a message box

How should my workflow look?

image

2

just add the missing closing bracket after toString

a more defensive approach:

isNothing(row(colname)) OrElse String.isNullOrEmpty(row(colname).toSring.Trim)

3

You can just get rid of those blank rows by using a filter datatable activity,
Selecting the “Remove rows option”
And specifying that if a particular column, or an aggrupation of them with And conditions are empty, consider it as a blank row and erase it.

4

@Sebastian many thanks for your feedback.

Can I ask for your help with completing the activity criteria?

image.png

For context: my workflow is reading a CSV file, and mapping individual fields to a web form. For some fields there is a requirement to perform additional extraction like in my example below. I am using a Regex expression for this. The problem is the CSV file created by the source system includes gaps!

image.png

Best regards

Andrew

Andrew Haworth

Solution Architect, EMEA LATAM

Roche Information Solutions

mobile: +353861702852

email: andrew.haworth@roche.com

Confidentiality Note: This message is intended only for the use of the named recipient(s) and may contain confidential and/or proprietary information. If you are not the intended recipient, please contact the sender and delete this message. Any unauthorised use of the information contained in this message is prohibited.

Privacy Note: At Roche, we understand that protecting privacy is very important and that information about you and/or your health is particularly sensitive. That is why we treat your “personal data” according to the “Roche Directive on the Protection of Personal Data”, and in accordance with the laws of England and Wales including the Data Protection Act 2018, and other applicable EU law including the General Data Protection Regulation (“GDPR”), which regulate the storage, processing, access and transfer of personal data. Our privacy policy is available here:

https://www.roche.co.uk/content/dam/rochexx/roche-co-uk/documents/PP_RD.pdf