Data Appearing as Rows Instead of Attributes (Columns)

blake_galbreath

Hello,

I am trying to get 2 entities from a website using Xpath:

//h:h2[(@class='uvIdeaTitle')]/h:a/text()

//h:div[(@class='uvIdeaVoteCount')]/h:strong/text()

I get all of the correct data, but they appear as sequential rows, instead of separate columns under the Results tab.

I am using the following process:

Read Excel > Get Pages > Data to Documents > Process Documents (Cut Document).

How can I retrieve the data in the following structure:

URL -- Idea Title -- Vote Count

instead of

URL -- Idea Title

URL -- Vote Count

Thanks,

Blake

yyhuang

Hi@blake_galbreath

You will need pivot operator.

<宏/ >









<参数键= "tt_name" value=""idea_tittle""/>







<参数键= "tt_name" value=""vote_count""/>

Cheers,

YY

blake_galbreath

Thank you!
Blake