This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've also gone ahead and written the macro for you - please see attached and also the workflow that calls it. Note that the files have a lot of nulls rows, so to see the real values, you just have to filter the nulls out.
Thank you for the solution.Now what I am facing issue is I am not able to write the output of the macro into a tde.The file is getting created but however it has only 30KB.Not sure what I am missing here.My output has to be a tde which can connect to tableau file.Can you please help?.
I tried with .xls format with this macro however it is not reading the second file.
With .xlsx and .csv it is reading Air_Mar and Air_Jan files however not writing the output as a tde.