Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to load ".OUT" files in qliksense

hi all,

trying to load .out files in qliksense. Please find the attached sample file.

4 Replies
robert_mika
Master III
Master III

LOAD

    @1,

    @2,

    @3,

    @4,

    @5

FROM [lib://My folder/FileTest.out]

(txt, codepage is 1252, no labels, delimiter is spaces, msq);

use Space as Delimiter when prompt in Data Loader

You can change @1 to @1 as ...

Anonymous
Not applicable
Author

hi robert,

thanks for your reply.

if its possible please upload sample file because when i am trying to load that file using qliksense i didnt even find the file in the folder i guess it because of the file is '.out'. do i need to select any option in edit script to find this file to load.

please advice

thanks

robert_mika
Master III
Master III

Please see attached:

-------------

Feeling Qlikngry?

How To /Missing Manual(18 articles)

----------------------

Ralf-Narfeldt
Employee
Employee

If you use Qlik Sense 2.0.1:

1. Create a new app

2. Click on Add data

3. Click Connect my data

4. Click All files

5. Browse to your .Out file, select it and click the >

6. Select File format Fixed record

7. Click Field breaks

8. Click in the preview area where you want to put the field breaks

9. Click Data preview

10. Check Select all fields

11. It's a good idea to rename the fields, like @1:11 to Date for example. Click on @1:11 and type Date, then continue with the other fields.

12. Click Load and finish