How to write the json data into excel into rows?

Help Studio
, ,
21

Hi please look the json

boefiletoday.txt (1.4 KB)

22

That is still a 2 line (2 items) document.

23

hi please look this

boefiletoday.txt (1.6 KB)

24

Hi ,
Is it fine now check the above file now

25

Did you manually edit the above file or is it an original file?

26

i manually edit that file now because some times line item may contains 2 or 1 and more according to that it has to print for supose if key is having AMOUNT_7 : NULL

in excel is has to write null that all what ever the value is having for preceding key i has write accordingly into row by row in same cell

27

Hi sudster,

are you there?

28

hello bro r u there???

29

is it possible to connect bro now ??

30

Are you there bro please respond atleast

31

@naveen5 , it is almost bedtime for me here, but I’ll post another solution for you.

32

sure bro please post it bro

33

@naveen5 , hopefully this is what you are after:

image
image1233×115 6.22 KB

Please confirm.

You can filter the datatable to keep/remove the columns you need.

Here’s the xaml file:

Sequence.xaml (31.8 KB)

I haven’t spent time to optimise the process; it should be possible to reduce the number of steps by changing the logic.