Dynamically Extracting Tables from a single excel sheet and then Union them Manually

[JashwanthK]

Greetings of the day,
 
I have a very long excel spreadsheet wherein I have multiple tables separated by two blank rows at the end of each table. 
I want a way using which I can extract all these tables and union them manually to create a single large table.

I am attaching images of the input and expected output with the spreadsheet input file.  

Many thanks in advance for any answers and guidance,
Jashwanth Baba

[Chantelb]

Hi Jashwanth,

You can easily filter out the blank rows by filtering out the null rows, for example put this in a filter tool: !IsNull([Column1]).

Then it just depends on the layouts of your tables to rename the column headers and filter out the column headers.

Let me know if this helps!

Cheers,

Chantel

[PanPP]

Hi @JashwanthK 

I have provided a sample WF that matches your output.

Hope this helps, if it does please like this post/mark it as a solution.

[JashwanthK]

Thanks for the response @Chantelb .The fields are sometimes shuffled, I would want to extract the tables with column names and then configure manual union to build a single table

[JashwanthK]

I want to dynamically extract the tables, the row count for each sub-table might change.

[PanPP]

Hi @JashwanthK 

In the sample WF - there are 2 ways to achieve your output.

Hope this helps, if it does please like this post/mark it as a solution.

[grazitti_sapna]

@JashwanthK , One way of doing this is selecting records using select records tools and then using Union to manually re arrange fields. Pleas find the solution attached and let me know if it helped:

[JashwanthK]

---

@grazitti_sapna wrote:

@JashwanthK , One way of doing this is selecting records using select records tools and then using Union to manually re arrange fields. Pleas find the solution attached and let me know if it helped:

---

I want to do it dynamically, there are too many tables in the spreadsheet, so using select records is still a tedious task to perform

[JashwanthK]

---

@PanPP wrote:

Hi @JashwanthK 

In the sample WF - there are 2 ways to achieve your output.

Hope this helps, if it does please like this post/mark it as a solution.

---

Thanks for the response. The fields are sometimes shuffled, I would want to extract the tables with column names and then configure manual union to build a single table

[EN6924]

Hi,

Please check if this works -

Thanks