Hi,
I have extracted the list in JSON file to an excel file using ListExploder. However the result didn't come out as expected:
Any suggestions on which transformer can I use to get the expected result as attached:
Thank you in advance.
Solved
How to extract list in JSON to Excel file
Best answer by caracadrian
Use ListElementCounter to get the total number of elements, ListExploder to separate into features.
Use AttributeManager to create 4 new attributes (your list appears to have 4 columns) with conditional values: if
@fmod(@Value(_element_index),4)=0than give the first attribute the value of station_info_apims, =1 the second, =2 the third and =3 the fourth.
Than create a fifth attribute that will become the new index with the value:
(@Value(list_count)-@Value(_element_index))/4+@fmod(@Value(_element_index),4)/4And just use an Aggregator with GroupBy your fifth attribute Mode set to Attributes Only and Accumulation Mode set to Merge Incoming Attributes.
I attached a sample workspace.
+23- Contributor
- Best Answer
Use ListElementCounter to get the total number of elements, ListExploder to separate into features.
Use AttributeManager to create 4 new attributes (your list appears to have 4 columns) with conditional values: if
@fmod(@Value(_element_index),4)=0than give the first attribute the value of station_info_apims, =1 the second, =2 the third and =3 the fourth.
Than create a fifth attribute that will become the new index with the value:
(@Value(list_count)-@Value(_element_index))/4+@fmod(@Value(_element_index),4)/4And just use an Aggregator with GroupBy your fifth attribute Mode set to Attributes Only and Accumulation Mode set to Merge Incoming Attributes.
I attached a sample workspace.
caracadrian wrote:
Use ListElementCounter to get the total number of elements, ListExploder to separate into features.
Use AttributeManager to create 4 new attributes (your list appears to have 4 columns) with conditional values: if
@fmod(@Value(_element_index),4)=0than give the first attribute the value of station_info_apims, =1 the second, =2 the third and =3 the fourth.
Than create a fifth attribute that will become the new index with the value:
(@Value(list_count)-@Value(_element_index))/4+@fmod(@Value(_element_index),4)/4And just use an Aggregator with GroupBy your fifth attribute Mode set to Attributes Only and Accumulation Mode set to Merge Incoming Attributes.
I attached a sample workspace.
Thank you so much for your answer! I'm new to this FME and your answer really helps me. I will try your solution to resolve this issue.
Thanks again!
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.