Data source sheet number selection

[Shekhar Deshin1]

Hello,

I am getting data source table xyz having following Sheet Number 5 and Header row 1.However client is sending the file via inbound email.File contains 1 xlsx file & only 2 worksheet inside (abc & xyz) i would like to know what is reason behind of selection as sheet number 5? However functionality works fine.

Thanks

[Alberto Consonn]

Hi,

Header Row and Sheet Number are used to specify values when an MS Excel file is the data source. For CSV files, the client just sets these to 1.

In your case, it's just not meaningful, you can put what you want, it will always work as expected.

Hope this will clarify your doubt.

If I have answered your question, please mark my response as correct and/or helpful.

Thank you very much

Cheers
Alberto

[Dhananjay Pawar]

Hi Shekhar,

As per me if you are mentioning greater sheet number than sheets then it takes last sheet.It will not take other sheets.

Thanks,

Dhananjay.

[Shekhar Deshin1]

Hello,

I am not getting you

Client is sending only 1 excel sheet,inside that have 2 work sheets (abc & xyz).While creating data source why it is mention sheet number as 5 ?

Here both the data sources are attaching same file only it takes different data from (Worksheet abc) and (Worksheet xyz) . Target table will be only one.

One data source sheet number is 5

another data source sheet number is 6.

Thanks,

[Alberto Consonn · Accepted solution]

It means that your work sheet "abc" and "xyz" has been defined as sheet number 5 and 6 in the Excel file.

Probably in your Excel file source, there are some other hidden work sheet.

I've just tested the behavior in my PDI using Load Data, if I delete a worksheet from my Excel file to be imported, the count of sheet will be different, so if I choose Sheet number 2, it will not import any data because in the Excel file the worksheet 2 has been deleted.

Hope this will clarify your doubt.

If I have answered your question, please mark my response as correct and/or helpful.

Thank you very much

Cheers
Alberto