semi structure data

Question

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

semistructure.xlsx

Qiu · Answer

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

Dillibi · Answer

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

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

Qiu · Answer

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