DSXchange

As far as I know ABAP plugin supports only basic conditions like IN, LIKE, BETWEEN etc. I dont think Build Sql Query option has features like substring or left etc.

You need to manually edit the ABAP program generated by the plugin to include any extra logic required by you.

If you are using Server edition of Datastage, then you wouldnt see a lookup stage. It is only present in the Enterprise/PX edition. When I meant lookup, I meant the hash file stage, which can be used for a lookup in server jobs.

Hi Marco, You can use File structure1 as input and the File structure2 as lookup (using hash file) Read the File structure2 from the source (.csv) file into a hash file and then use this hash file as a lookup for File structure1 (Input) and if y ou find a match on the Key_col, then transfer all the ...

You can try what sainath suggested above or alternatively, you can use a regular sequential file stage and put the file name as .csv. Then you can import it in excel directly and if you want it in .xls format, then you can save it in .xls format using excel.