How to structure the excel data as Table and give it a Table Name?

Hi guys,

I want to know how to structure the data from excel as a Table and give them a
“Table Name” since I want to create a pivot table, and it needs a Name of the Table but not a name of DataTable variable.

Thanks!

2 Likes

Hi
Yah that’s possible we got certain set of activities for TABLE creation

Cheers @opas1216

Thanks for helping!

I already tried this activity before, but the question is the create Table has to give it a specific range, isn’t it? I couldn’t give it a specific range cause the data is not fixed range.

And another activity “Get Table Range” which requires a Table name, it’s kind a loop.

Thanks @Palaniyappan

1 Like

Hello @opas1216
you can use RowCount and ColumnCount to get the dynamic range and than use Create Table Activity to create a table for that particular sheet
Check this workflow for better understanding.
DynamicTable.xaml (10.1 KB)

2 Likes

hi, when i create table, it shows table overlap error. any help is appreciated!

Hello @winnie_toh

A table is already created on that excel sheet. So its giving you that error. Remove the table from that excel sheet and try again or add a try catch to catch that error if a table is already created.

1 Like

Yes silly me, I realised that and resolve it. Thank you so much!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.