How to count all empty fields in Biztalk
I am a new user of biztalk. I am using Biztalk 2006 Beta version. I am receiving a positional flat file in which few elements (for example CaseNumber) can be empty. I need to loop through each record and check if CaseNumber is empty/null. If it is empty then I need to increment a counter variable. Finally I need to assign this value in a new message and send to send port.
I know how to draw orchestration to receive the flat file and how to create the schema for it. But I failed to check the element of the message if it is empty (like this in Decision Shape message1.CaseNumber==null)
Can anybody help me to solve this?
Thanks in advance