How Load to the unstructured data in to Qlikview, my problem is how to avoid the spces ,tabs in the below example ...........
You can format it in the script editor. Find the attached screenshot. Regards. Siva
1.Load file in file wizard
2.Select the delimiter Spaces
3.Make header size--> Lines--> 2
5.Give next-->Click on Enable Transformation step-->delete any empty rows/columns if required-->OK
Check attached File.
Just digging around for thoughts on unstructured data.
Just a quick one on this post. This is not unstructured data it is fixed width data. Each section of data has its own set of characters.
You can Generic Load PFA sample.
Retrieving data ...