JSON Missing data issue

HI

I am having JSON files which often contain missing values and when I put it as a list the missing values get assigned to the wring row and the data goes all wrong.

I have looked at the forum and I am not able to figure it out. I have attached the sample flow. Can someone help?

Thanks

test data.knwf