Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

kanimozhi
New Contributor II

How to load ".OUT" files in qliksense

hi all,

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

4 Replies

Re: How to load ".OUT" files in qliksense

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 ...

kanimozhi
New Contributor II

Re: How to load ".OUT" files in qliksense

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

Re: How to load ".OUT" files in qliksense

Please see attached:

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

Feeling Qlikngry?

How To /Missing Manual(18 articles)

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

Employee
Employee

Re: How to load ".OUT" files in qliksense

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

Community Browser