DATAEXPORT Calc Script Error
Summary
DATAEXPORT Calc Script ErrorContent
Hi,
I'm using a Calc Script to export a partial data into a File. When I see the export file I see that the export contains 2 header rows with all the dimensions in the first row and all the "Measures" in the second row since I used DataExportColHeader "Measures". Now back in ODI, it is unable to recognize this Flat File. When I'm doing reverse engineering, it's just picking up the first row of dimensions and sorting the rows accordingly which is actually deviating from our purpose to extract right columns of data.
So is there anything I need to change in my below Calc script to export right dimensions in just one row? Please Advice?
0