i have 4 csv what i need to do is i need to append all one after the other but i dont need to add headers and need one empty row between each appended how to do it can any one help pleaese
i am adding the screenshoot that i need finally
i have 4 csv what i need to do is i need to append all one after the other but i dont need to add headers and need one empty row between each appended how to do it can any one help pleaese
i am adding the screenshoot that i need finally
Hello @manoj2500,
you can append only rows which have data by filtering them out or by looping in my example:
row(0).ToString.Length > 0
Also you have a nice article for filtering DT:
Cheers,
Dino