02-11-2014 08:24 AM
we have a SAS table as Source with a Column (for ex. Quatitiy) having cell number of excel file (for ex. A5).
1. We Have to read A5 (value written in column Quantity) from SAS table.
2. Read an another Excel File and Retrieve the value written in cell no. A5 in this excel file.
4. Mapped this value to the target table column.
In this scenario we are using source table for retrieving the required cell no. and in target table the value (from Excel) written in this cell no. must be assign.
Is it possible with Enterprise Guide or Data Integration?
Can we read the value of cell from Excel if we have the cell no.?
Or Any other Idea?
Thanks in advance