Hi Pellegrino, With a little bit of simple coding. Just use a tFileExcelInput and set only one column as dynamic type. Then using the dynamic type functions you should be able to count the number of columns that it retrieved.
My input is Excel file (attached) The Expected Output is to load the values into temp table (SQL SERVER). I am attaching the Excel file, the values in the first column "CPT" and the values in the second cloumn ICDCOVERED , I need to load these values. The first cloumn and the second cloumn have 1 to many relationship, Problem 1: In the Excel file when does not a value in the first column, that it show continue to load the data until it comes across the next value. Problem 2: In the second column (ICDCOVERED), some cell values are individual values like (003.1), some cells have multiple values like (606.02, 607.01) and some cells have values ranges for example: (503.02-503.09).
My objective is to load the data one value in each row of the temp table, when it is multiple values in the cloumn it should load values into seperate records, and when it is a range it should query the range from the database table get the range of values and load the values into seperate records in the Temp Table, this is regarding the ICDCOVERED colum of the Excel file. Now for the CPT column of the Excel file it should maitain the 1-many relationship while loading the data. Hope I am clear now. I am really not able undersatnd the way I can accomplish this. Sorry I am not able to pose this question on the forum, I am confused where I have to type my question in the forum. Please I would appreciate if you can reply back to this e-mail address. Ali