How to created datatable through unstructured data

Build Studio
, , , , ,
#1

Hi there,
Does anybody know how to build a data table from unstructured data? I scraped data from various locations and separated useful data through string manipulation.

But now I am facing a problem of appending all data within a single excel sheet.

I want to append data into given format.

Extract_Company_Data.xaml (44.9 KB)

Screenshot (46)
Screenshot (46)1366×768 57.7 KB

Please help me out guys!!!

#2

@AMRITANShlal To Append all data within a Single Excel Sheet, we need to know what is the relation between them, So that we can join them together.

2 Likes
#3

Hey @AMRITANShlal :wave:

Hoping that your string manipulations create a collection of similar data, you can use a Build Data Table activity and pass the data to the data table using Add Data Row inside a for/while loop.

1 Like
#4

@supermanPunch
There’s no relation between data except they’re of type String.

#5

Thanks @monsieurrahul

Yes the data is of type String.
I but my concern is hot to append all the data in single row?