Input file - how to make my workflow detect beginning and end of table in excel?

Question

Hi all,

My workflow reads in a table from an Excel file on monthly basis (cell range is specified in the configuration), challenge that I am facing is that the range of table might change. New rows might be added.

For example, the first table is data for July, the second table will be for August (two new rows added). how do I set up my workflow so alteryx can detect the new beginning and end of table? Thanks!

column 1column 2column 3apple

orange

column 1column 2column 3apple   watermelon

orange

cjaneczko · Answer

@rzz0419999 wrote:there's no way of knowing how many rows will there be each month, the report owner might add three rows this month, and two rows next month .

You don't need to know the number of rows. You only need to know what the data looks like at the last row you are looking to keep and the first row of the next table. You create logic that filters out all of the data below the last row. It could be a heading or change in the structure that indicates where the data ends.

rzz0419999 · Answer

thank you so much! let me try to mock something up.

rzz0419999 · Answer

there's no way of knowing how many rows will there be each month, the report owner might add three rows this month, and two rows next month .