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.
Thank you @CarlDi . But the data is not clean. Please see the below screenshot. Even if i use Text to Column tool, 4th column has text field and it's not formatting file properly. If you see below screenshot, I would need 1st Record and the next 4 records are to be in same line in 1st Record. My 2nd Record should be the 6th one which you see below.
@indras111 I see. Another modification you can make is to change the #5 Delimiters in the Input data tool to \t - this is tab delimited. The result will be a majority of the data being split out accordingly. Furthermore, you can add a dynamic rename tool, select all and take field names from the first row of data. The result is below.. At this point, you can filter out the dirty fields that aren't in a tabular format?
the first 4 records were actual data the remaining fields are dummy data. I would need to fix that to have all the data filled in Req notes being displayed in one cell. I have around 20,000 records similar to the first three records.