Share
Report
357Hi Team,
I have json file which has 30K lines.
I have successfully extracted data from it and save it in word file.
but my flow took 4hrs for this process.
I want to eliminate overall processing time.
current my flow is like this
Extract data store it in DT
Save as csv
csv to word
This is for getting table headers from json
This is for data extract from json
Json data is like this
"84": {
"raw_material_table": {
"headers": [
"Sr. No.",
"Raw Material",
"Molecular Wt.",
"Moles",
"Mole Ratio",
"Quantity",
"Source",
"A. R. No.",
"Purity"
],
"rows": [
{
"Sr. No.": "G1",
"Raw Material": "fosaprepitant",
"Molecular Wt.": "",
"Moles": "-",
"Mole Ratio": "1.0",
"Quantity": "72. 0 gr",
"Source": "Fos/R.18211078",
"A. R. No.": "088 =",
"Purity": "22 gm2"
},
{
"Sr. No.": "-",
"Raw Material": "Donc.",
"Molecular Wt.": "-",
"Moles": "",
"Mole Ratio": "-",
"Quantity": "-",
"Source": "fos/R.18h/1078)",
"A. R. No.": "100 =",
"Purity": "22 gm"
},
{
"Sr. No.": "-",
"Raw Material": "-",
"Molecular Wt.": "",
"Moles": "",
"Mole Ratio": "",
"Quantity": "-",
"Source": "for / R/83/1078",
"A. R. No.": "138 =",
"Purity": "28 gm"
},
{
"Sr. No.": "02",
"Raw Material": "meant.",
"Molecular Wt.": "1",
"Moles": "-",
"Mole Ratio": "1000",
"Quantity": "72ml.",
"Source": "commecial",
"A. R. No.": "ARDY/12/05/",
"Purity": "72.0 gm."
},
{
"Sr. No.": "03",
"Raw Material": "SPA.",
"Molecular Wt.": "-",
"Moles": "A",
"Mole Ratio": "5.000",
"Quantity": "360ml.",
"Source": "Commential",
"A. R. No.": "AROH/12/025",
"Purity": "- -"
},
{
"Sr. No.": "02",
"Raw Material": "Acetone.",
"Molecular Wt.": "",
"Moles": "-",
"Mole Ratio": "-",
"Quantity": "5600",
"Source": "commecial",
"A. R. No.": "A004/ 12/050",
"Purity": "-"
}
]
},
"operation_table": {
"headers": [
"Sr. No.",
"Operation",
"Time From",
"Time To",
"Temp.",
"Observation"
],
"rows": [
{
"Sr. No.": "0%.",
"Operation": "Arranged 2-0lit BF.",
"Time From": "13:00",
"Time To": "14:00",
"Temp.": "-",
"Observation": ""
},
{
"Sr. No.": "",
"Operation": "charged 72.0 gro Fos.",
"Time From": "13:00",
"Time To": "14:05",
"Temp.": "20\u2103",
"Observation": ""
},
{
"Sr. No.": "03.",
"Operation": "charsed IPA 360 ml.",
"Time From": "14:5",
"Time To": "13:10",
"Temp.": "2 \u2103",
"Observation": ""
},
{
"Sr. No.": "on",
"Operation": "charged Been 72.0 ml.",
"Time From": "13:10",
"Time To": "14:15",
"Temp.": "28 \u2103",
"Observation": ""
},
{
"Sr. No.": "",
"Operation": "stirred for 30 min:",
"Time From": "14:15",
"Time To": "",
"Temp.": "2\u2103",
"Observation": ""
},
{
"Sr. No.": "00",
"Operation": "noded slowly Acetone 3600h",
"Time From": "hs",
"Time To": "15:15",
"Temp.": "28 \u2103",
"Observation": ""
},
{
"Sr. No.": "03.",
"Operation": "stirred for 2.0hrs,",
"Time From": "15:15",
"Time To": "17:15",
"Temp.": "20\u2103",
"Observation": ""
},
{
"Sr. No.": "08",
"Operation": "filhosed",
"Time From": "17:15",
"Time To": "17:18",
"Temp.": "28 \u2103",
"Observation": ""
},
{
"Sr. No.": "05",
"Operation": "Cocke washed with",
"Time From": "17:18",
"Time To": "17:19",
"Temp.": "25\u2103",
"Observation": ""
},
{
"Sr. No.": "-",
"Operation": "200 Ml Acetone -",
"Time From": "-",
"Time To": "-",
"Temp.": "-",
"Observation": ""
},
{
"Sr. No.": "10",
"Operation": "sucked wellof whoades",
"Time From": "17:17",
"Time To": "17:20",
"Temp.": "~8\u2103",
"Observation": ""
},
{
"Sr. No.": "11",
"Operation": "Dried in motanapor for",
"Time From": "17:00",
"Time To": "12:50",
"Temp.": "30%",
"Observation": ""
},
{
"Sr. No.": "-",
"Operation": "30 min.",
"Time From": "-",
"Time To": "-",
"Temp.": "-",
"Observation": ""
},
{
"Sr. No.": "12",
"Operation": "Died in VIA at 25-30\u2103",
"Time From": "18:00",
"Time To": "-",
"Temp.": "27\u2103",
"Observation": ""
},
{
"Sr. No.": "-",
"Operation": "for overnight.",
"Time From": "",
"Time To": "10:00",
"Temp.": "262",
"Observation": ""
},
{
"Sr. No.": "13",
"Operation": "",
"Time From": "10:00",
"Time To": "10:05",
"Temp.": "20\u2103",
"Observation": ""
},
{
"Sr. No.": "14",
"Operation": "By MY = x 69.5 gm.",
"Time From": "-",
"Time To": "-",
"Temp.": "",
"Observation": ""
},
{
"Sr. No.": "",
"Operation": "",
"Time From": "",
"Time To": "",
"Temp.": "",
"Observation": ""
},
{
"Sr. No.": "",
"Operation": "",
"Time From": "",
"Time To": "",
"Temp.": "",
"Observation": ""
}
]
},
"Exp_info": {
"headers": [
"EXPERIMENT NO.",
"DATE",
"OBJECTIVE",
"CONCLUSION",
"Done by",
"Witnessed / Reviewed by",
"Date",
"Date",
"MOBILE PHASE",
"OBSERVATION AND ANALYTICAL DATA",
"Done by",
"Witnessed / Reviewed by",
"Date",
"Date"
],
"rows": [
{
"EXPERIMENT NO.": "fos/R.18211078/152.",
"DATE": "21.MAY.12.",
"OBJECTIVE": "Purification of for once.",
"CONCLUSION": "Dy or = 69.5 gr .",
"Done by": "(11)og tag",
"Witnessed / Reviewed by": "Niel Auch",
"Date": "2) MAY.12 Q2.",
"MOBILE PHASE": "",
"OBSERVATION AND ANALYTICAL DATA": ""
}
]
}
},
I am iterating through
raw_material_table and create its word file same for Operation_table and Exp_info
Tell me how I can reduce the time ?
I am iterating through
raw_material_table and create its word file same for Operation_table and Exp_info
Tell me how I can reduce the time ?
Categories:
I have the same question (0)
All responses (
Answers (
