Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
trying to load .out files in qliksense. Please find the attached sample file.
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 ...
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
Please see attached:
-------------
Feeling Qlikngry?
How To /Missing Manual(18 articles)
----------------------
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