Output in a single line while using Data scraping

Help Studio
, , , ,
1

Hi all,

I’m using Data scraping tool and when I implement it, I am getting the desired output but when I write it in excel sheet its comes in a single line.
Please find the Screenshot for better understanding.
image

I want it in the below format.
image

The extracted Metadata from the data scraping is:

image

Can anyone help me?

Thanks in Advance

2

As you are extracting data from webpage this are columns as you can see in metadata that is why they are come in single line
can you share workflow

1 Like
3

Hey @ImPratham45
Thanks for the reply.

webpage- Jobs 2022 - Search Jobs in India, Latest Job Vacancies, Recruitment - Shine.com

4

From where you are extracting
share screenshot

1 Like
5

Hi @ImPratham45,

The screenshots is just a example, I was trying to extract the data after I fill the details and click submit for a job search.
The area where I fill in the details is shown in the screenshot below.

image
image1296×204 41.7 KB

Thanks in advance

6

Hi @ImPratham45,

Sharing the workflow.
extractData.xaml (7.5 KB)

7

Why you are extracting same data which u have entered
nd if you want single line data then u can capture using get text or other text scrapping activity as u are using data scrapping it will used for structured data
For Reference

8

Hey,
I don’t want to extract the data that I entered,
After I hit Submit, I’ll get a list of outputs.
That is what what I want to extract.

Thanks in Advance!

9

share that page link so that i can make sample

10

Hey,
I’d pasted the link.
Here’s the link.
https://www.shine.com/#

Thanks in advance!

11

ShineData.xlsx (12.3 KB) ShineScrap.xaml (9.5 KB)
Check This workflow
and link
https://www.shine.com/job-search/jobs-in-bangalore?loc=Bangalore

2 Likes
12

Hey @ImPratham45,

yes!!
This is what I wanted.
Can we get the link/URL column?
which is URL to these postings.

Thanks in advance!

Thanks in advance

13

Yes you can follow same process for data scrapping and add url column in it

1 Like
14

Hi @ImPratham45,
Thanks for the reply.
Sorry for the delay.

For url, the link comes up at the same place for any selected item,
So it takes the first input while data scraping, for the second one, I’m getting an error.

Attaching the same.
image

Any suggestion or help?

Thanks in Advance!

15

ShineScrap.xaml (9.5 KB)
Pls chk

16

Hi,

Thanks for the reply.

17

Your Most Welcome :blush:

18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.