I need to validate the Excel file schema with metadata schema
Please help me out to find the component which can do this ?
This can be done by using tSchemaComplianceCheck component available. This component validates the input schema with the schema defined on this component. Hence, the schema you have under metadata can be set on this component where your excel file can be main input of this component if I rightly understand what you are trying to do.
I guess we can only compare, type/Nullable/length/Data Pattern through tSchemaComplianceCheck.
I hv achieved this by joining 1st complete row in input csv file and lookup with tFixedFlowInput
ex : BUSINESS_DAY|RECORD_COUNT|SALES_SUMSSSS9999 (input file 1st row)
Yes we can compare only type,length,Data Pattern through tSchemaComplianceCheck,
is there any way to compare columns
In my metadata
In my file below are the columns
I need validate file schema with above metadata list.
Please suggest me. is there any way to do this?