GitHub user Raja10D added a comment to the discussion: How to Dynamically Pass Input to Microsoft Excel Input Transform?
> At the moment we have no way available of "guessing" excel schema's at > runtime. We expect the input to be configured for the excel file it will be > reading. If your goal is to extract information from a large set of different > excel types there are 2 options. option 1: You know the schema of each "type" > of excel file --> Use Metadata injection option 2: You **do not** know the > schema of the file --> Use the Tika transform this transform can extract data > from a number of file types Actually I have kept the fixed schema in my excel input component and enable the accept fields from previous transform for getting the excel input path dynamically **Problem facing:** Even if the column is not present it is giving the columns with all row values <null> which is good for next processing But what I need is that if the sheet has 10 columns(requirement) only, I need to go the excel input component itself because after the excel input component we are having all 10 columns, even though the columns are not present in the sheet due to the schema we have given in the Excel input component. Is there any way to tackle this issue with Hop, if sheet has 10 columns proceed otherwise abort This is what I need? If anybody knows help me GitHub link: https://github.com/apache/hop/discussions/5050#discussioncomment-12576372 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
