wingsoftechnology.com
GET EXCEL FIRST SHEET NAME USING UNSTRUCTURED DATA STAGE - Wings Of Technology
We know we can give hard coded sheet name or parameterized sheet name while reading excel data from unstructured data stage. But the problem comes when you want to read data from excel in specific sheet number such as first sheet or second sheet and so on. If you know sheet name, you can directly hard code sheet name there. But if sheet name is changing everytime, there is no direct option to read data from specific sheet. I will show you how to read specific sheet name using a parallel job and you can pass this input to next