I have to remove the space in between the lines. I'm getting input file from txt file and need to provide output in text file Using Union Tool to merge two set of data, where in first set has less number of columns and 2nd set have more number of columns
Unclear if you want row 1 removed? If so then use the filter tool. Choose a field that would indicate the row doesn't belong. Field 8 is Null and row 1 would be removed if filtered to Field 8 Is Not Null.
I need Row 1 as well, But after Field 8 there was no data available Also for next rows, there are more number of field While trying to merge both using "UNION" tool, the null fields in row 1 create a space in text output file(Capture Picture)
Input file and Outfile format are similar to picture named "Capture". On the input file, There is no space inbetween the two lines. But on the outfile file, there is space
