Read Collection Column name w.r.t ROw

[SaumitraSharma]

Hi,

I need one help, I have collection in that collection i have to read the column name of the row which is having value "O" in collection row.

Also my input file column has dot and dash also in the column names.


------------------------------
Saumitra Sharma
Consultant
Wipro Digital
Indian/Christmas
------------------------------

[WojciechFurmans]

Hi,

Maybe try to download the column names and then filter through the expected value loop by examining the number of rows in the output of the collection

------------------------------
Wojciech Furmanski
Consultant RPA
Digital Teammates SA
Europe/Warsaw
------------------------------

[JaredRumball]

Hi Saumitra,

Is this a single row collection? If so, then try transposing the collection first - an action for this is available in the Collection Manipulation utility object. You will then have a Name/Value pair collection which you can loop through to check for "O" in the Value column and then read what is in the corresponding Name column.

Regards,
Jared

------------------------------
Jared Rumball
Q4 Associates Ltd
https://www.q4associates.biz/
------------------------------