Hi team,
could any please connect for this i will explain just 10 mins please
boefiletoday.txt (1.4 KB)
is any one availble please i tried using deserialize jsonarray but it not working please some one connect i explain what was the issue iam facing it really helpful for me if could connect with me
Hi @naveen5
Deserialize should have worked, can you put a breakpoint and check on what the output is before and after the breakpoint?
After deserializing it, you can write the data into the excel by creating a datatable out of the deserialized data.
I tried the data is writting in different format can you connect please
Connecting right now would be little difficult @naveen5 as I am travelling.
You can share some more informative screenshots, I can possibly look through and try helping.
Try with deserialize json, not array.
@naveen5 , from your sample data, it doesn’t look like you can directly convert it to a datatable and then to Excel. May be post a sample output Excel file.
my data is writing into excel in same cell
for example :- Unit_Price
3300
200
but it storing like this
"/[
"“3300.000000"”,
““200.000000"”
]”
Hi bro,
Are you there bro?
Please post an Excel that reflects your expected output - manually edit the Excel data to suit.
no bro,
i want get the data into cells
if unit_price
3300
200
like i have to get
@naveen, as requested previously, show the output exactly as you want it in an Excel file or in a screenshot.
Like this?
hi please see the actual output i need
BOE.xlsx (9.1 KB)
Have u got it @sudster
@naveen5 , I think I understand the requirement.
What happens if there are 10 items in the document? How to identify NULL/Empty fields corresponding to which row?
Hi Sudster,
Are you there??
if json is having null it give null values
@naveen5 , can you provide a json with more number of lines, rather than the current 2?