Transposing lists into multiple groups

I don’t know if you want to try generating a CSV for this instead. I’m not sure how to dynamically rename columns in excel otherwise. I am able to group the values in the way that I think you are asking. I assumed in my workspace that you can group by filename for each row. I used the exact input you showed only in your screenshot. So my output is incomplete, but it would work on complete data the same. I hope this is decipherable. This is not the prettiest workspace, but it might help you to get closer to what you want.

First I am determining the columns needed, then I get values for all possible cells, then I aggregate rows. It might be easier to do some steps using Python, but I decided to go this way. I’ve attached the template workspace I used with the csv input I used.

ev_robin wrote:

I don’t know if you want to try generating a CSV for this instead. I’m not sure how to dynamically rename columns in excel otherwise. I am able to group the values in the way that I think you are asking. I assumed in my workspace that you can group by filename for each row. I used the exact input you showed only in your screenshot. So my output is incomplete, but it would work on complete data the same. I hope this is decipherable. This is not the prettiest workspace, but it might help you to get closer to what you want.

First I am determining the columns needed, then I get values for all possible cells, then I aggregate rows. It might be easier to do some steps using Python, but I decided to go this way. I’ve attached the template workspace I used with the csv input I used.

 

 

 

 

Thank you! When I open your workspace it’s telling me I don’t have the versions of Duplicate Filter and Feature Merger you used. Could you attach summaries to those transformers so I can add them manually?

ev_robin wrote:

Absolutely! I hope this helps. In the feature merger, I merged every feature. I’ve attached a screenshot with all of the summary annotations for the feature merger and the duplicate filters.

 

Finally had the chance to look at this. Learned a lot from studying how you did this, never even considered the benefints of using csv here. 

Thank you very much!