My file contains Header values like below. "1" "2" "3" "4" "5" "6" I am able to process above Header value rows with their respective schema. but file has last schema with header value like !=1 || !=2 || !=3 || !=4 || !=5 || !=6 || !=7 || ==10 so is there any way to specify multiple Header values for a single schema with && or || operator please suggest.
Below is sample positional file which has 6 MS schemas. and each schema is separated with header value. here is the pattern for header value. "1,3,8,4 if you can see I am having below header value for 2nd field. those are as follows. 101 106 102 103 104 105 apart from above listed header value,we have to redirect not matching values to different schema.
@janhess i think you for solution but, i think you are not getting my question i have file with 7 different schemas. i am able to get all 6 schemas but using MS positional file but 7 th schema has multiple conditions so I am using reject connector to get any things else which is not matching with previous 6 schemas then using tmap to make 7 condition to redirect for 7 schema. apart from that i am searching for solution which will do it within a MS positional file. using tMap I have done it.
I Agree with you but i am having a Positional file which has multiple schemas. please see my example file paste. first schema has 100 columns second schema has 88 columns and so on for other not every schema has same number of columns. like that we have more than 7 schemas and each one is distinguish using one column value. in your scenario we have to read full row and then need to add Extract Positional filed component to get columns based on conditions. other wise we have to do sub string in Tmap to create columns based on schema. Check for MS Positional component.