topic Re: Loading statements to achieve the desired shape in QlikView

Loading statements to achieve the desired shape

Wed, 16 Apr 2014 17:26:45 GMT

Hey guys, I have a script that works with a .txt file that is attached. Recently I change this to a .brn file (specific from another program). When I load it inside, data comes different, with no tabs or spaces...

If you change the load to spaces as delimiter, data looks the better I can get, but i need to look like the .txt file, so it works...

Can someone help me out shaping this data?

Re: Loading statements to achieve the desired shape

Anonymous — Wed, 16 Apr 2014 20:52:37 GMT

Hi,

I have opened the .txt file and saved it as .brn file and tried to load the .brn file and found it is showing similar to that of .txt file.

Re: Loading statements to achieve the desired shape

Thu, 17 Apr 2014 01:43:10 GMT

yes, they are basically the same file, but i want a direct connection to the .brn, without having to save it as a .txt file... my script is working like this:

Raw:

LOAD @1,

@2,

@3,

FROM

[My restaurant.txt]

(txt, codepage is 1252, no labels, delimiter is '\t', msq, header is 0 lines, filters(

Replace(1, top, StrCnd(null))

));

Menu:

LOAD

@1,

if(@2='',peek('Course', RowNo()-2), @2) as Course,

if(@3='',peek('Plate', RowNo()-2), @3) as Plate,

@4 as Food

RESIDENT Raw

WHERE @1 = 'Menu'

;

Foods:

LOAD @1,

if(@2='',peek('Course', RowNo()-2), @2) as Course,

if(@3='',peek('Plate', RowNo()-2), @3) as Plate,

@4 as Food

RESIDENT Raw

WHERE @1 = 'Foods'

;

Ingredients:

LOAD @1,

if(@2='',peek('Course', RowNo()-2), @2) as Ingredients1

// if(@3='',peek('Dish', RowNo()-2), @3) as Dish,

// @4 as Ingredient

RESIDENT Raw

WHERE @1 = 'Ingredients'

;

will it work out the same if I use the ".brn" file?