semi structure data

[Dillibi]

Hi All ,

Want to load data into table from this semi structure data in excel.

Columns need in target table :

FileName Created by  Name Target value

Attaching excel with data for reference.

can anyone please let me know to design the workflow to process data into table

[Qiu]

@Dillibi 
Is something like this?

[Qiu]

@Dillibi 
Appreciate you will mark the solution as accept if you find it useful.

[Dillibi]

Thank you Qiu , It worked with with Excel . Appreciated.

Is there any setting for .csv file for the same data ?

[Qiu]

@Dillibi 
As long as you check this option, it should work.