Find Null/Empty Columns in a Collection

[vinodchinthakin]

Hi All,

May I know is there any way to find Empty/Null Columns in a collection.

------------------------------
vinod chinthakindi
------------------------------

[Satish1414]

Hi Vinod ,

You can use Utility -Collection Manipulation object and actions like "Remove Null rows" or "Remove Empty rows"

Hope this helps

Regards,
Satish Gunturi
Senior Consultant
Ignite IPA Pvt Ltd .

------------------------------
Satish Gunturi
------------------------------

[vinodchinthakin]

Hi Satish,

I don't understand how does it works. When I tried it simply removes empty rows, But my requirement is to find empty/null Columns

------------------------------
vinod chinthakindi
------------------------------

[ManpreetKaur1]

Hi @vinod chinthakindi,

You can use decision stage to identify the empty column by looping through all the records. The condition would be something like this (assuming Name is the column name):

[Name] = ""

Once you identify the empty column, you can perform the relevant actions.
​

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------

[vinodchinthakin]

Hi Manpreet,
We cannot compare an entire field to any specific value using decision stage. For that we can use loop, but it will loop row wise, so if there is any empty row found in any column(which has values in other rows) will be identified as Null.
So I am looking for a logic where we can find Null column looping column wise(which is against the rules) or some code stage.

------------------------------
vinod chinthakindi
------------------------------

[Satish1414]

Hi Vinod ,

You can try the below C# code if it returns  "True" you can simply delete the column 

Hope this helps .

Regards,
Satish Gunturi
Senior Consultant
Ignite IPA Pvt Ltd .

------------------------------
Satish Gunturi
------------------------------

[vinodchinthakin]

Hi @Satish1414

Can you able to provide above code in VB.Net. As my existing actions are in VB.net, so its easy to add above action in same VBO,​

------------------------------
vinod chinthakindi
------------------------------