Need to extract entity and region

Question

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 · Answer

@ryxnewbie Can you please export your workflow with inputs?

ryxnewbie · Answer

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 · Answer

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