topic RE: Read Collection Column name w.r.t ROw in Product Forum

Read Collection Column name w.r.t ROw

SaumitraSharma — Sun, 12 Apr 2020 10:34:00 GMT

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

RE: Read Collection Column name w.r.t ROw

WojciechFurmans — Wed, 22 Apr 2020 05:46:00 GMT

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

RE: Read Collection Column name w.r.t ROw

Jared.Rumball — Mon, 11 May 2020 11:20:00 GMT

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