Remove header rows from dataset in Merging process

Question

Hello Team,

While importing multiple sheets of excel from 1 file to create a base table in alteryx ( which is combination of all sheets) ,the Schema remains the same for all tables.

I am getting the header rows multiple times in the my output/Mered table of alteryx.

Can someone suggest me a way to clean up these rows from my final dataset

grazitti_sapna · Answer

Hello @namitajuneja , This usually does not happen when you merge the data from different sheets. Please check the configuration of input Tool. If your excel contains data in the first row and no headers then you need to filter out the records explicitly using Filter Tool:

else you can uncheck the First Row Contains Data option, in this way it will consider all first rows as header of sheets and will not load them as data. It should be:

Qiu · Answer

@namitajuneja 
So I guess you choose the "First Row Contains Data" in the input tool.

Can you try to uncheck it?

Christine_Assaad · Answer

Hello @namitajuneja

An easy way is to add a filter tool to filter out all records where Index field = the word "index".

In filter tool, you can from the drop down select Index, Operator: Does not equal and Value will be index. Out of the T side, you should find your dataset, as desired and out of F anchor, you will find all headers to be dropped.

Cheers!