I just added coalesce in the same syntax that you provided me first time and i did not use pandas and i got the file in one file as CSV . i am from ab initio (old ETL software ) background . so i was little confused . we have multifile and serial file system in ab initio.
thank you