Need to extract entity and region

[ryxnewbie]

Hi,

I am working on extracting entities and their regions from an excel spreadsheet that is compressed into different rows when you open an entity row. I have been able to separate out the entity through its own filter and the region from another filter. 

Here's my current flow: 

 

Now what I would like to do is extract the Entity & region on the same row instead of separate filters/rows: 

 

Is there a way of doing it? I appreciate the help. Thanks.

 

 

[nagakavyasri]

@ryxnewbie Use Join tool to get all the data in single row.

[ryxnewbie]

Hi @nagakavyasri, I tried doing that but it just added extra rows I did not need. So I am a little hesitant to do that. If you have done this before, can you please provide an example?

[nagakavyasri]

@ryxnewbie Can you please export your workflow with inputs?