How to Load unstructured data in to Qlikview - Qlik Community

Report Inappropriate Content · ‎2012-10-25

How Load to the unstructured data in to Qlikview, my problem is how to avoid the spces ,tabs in the below example ...........

Siva_Sankar · ‎2012-10-25

You can format it in the script editor. Find the attached screenshot. Regards. Siva

sivarajs · ‎2012-10-25

1.Load file in file wizard

2.Select the delimiter Spaces

3.Make header size--> Lines--> 2

4.Labels-->Embedded Labels

5.Give next-->Click on Enable Transformation step-->delete any empty rows/columns if required-->OK

amars · ‎2012-10-25

Hi,

Check attached File.

Thanks

Amar

DavidFoster1 · ‎2014-07-10

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.

vikasmahajan · ‎2014-07-10

You can Generic Load PFA sample.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.