Excel Input

How to get the fields from excel file , If that excel file has rows with sub rows

Daily_Break_Down_Report.xls (248 KB)

Hi! Nirmal,

I can see that the excel file has merged cells for column headers.

You need to ask Business to streamline and modify the heading format for the excel template. So that it is suitable for automation.

We can’t do anything with plugin?

You write a script in the VB Script step to demerge field etc.