topic Find Null/Empty Columns in a Collection in Product Forum

Find Null/Empty Columns in a Collection

vinodchinthakin — Mon, 18 Jul 2022 11:03:00 GMT

Hi All,

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

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

RE: Find Null/Empty Columns in a Collection

Satish1414 — Mon, 18 Jul 2022 11:35:00 GMT

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
------------------------------

RE: Find Null/Empty Columns in a Collection

vinodchinthakin — Mon, 18 Jul 2022 12:30:00 GMT

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
------------------------------

RE: Find Null/Empty Columns in a Collection

ManpreetKaur1 — Mon, 18 Jul 2022 15:22:00 GMT

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
------------------------------

RE: Find Null/Empty Columns in a Collection

vinodchinthakin — Tue, 19 Jul 2022 05:03:00 GMT

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
------------------------------

RE: Find Null/Empty Columns in a Collection

Satish1414 — Tue, 19 Jul 2022 15:14:00 GMT

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
------------------------------

RE: Find Null/Empty Columns in a Collection

vinodchinthakin — Wed, 20 Jul 2022 11:53:00 GMT

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
------------------------------