topic Load from an existing QLikView table in QlikView

Load from an existing QLikView table

Mon, 30 Dec 2013 19:39:25 GMT

all,

I would like to separate LOAD (in the main script) from clean up operations (in a clean up script).

also, I would like to load data in the clean up script from tables that i obtained loading data in the main script. so far i have

accountInfo:

LOAD Country,

[Corporate Account],

[Sales Account],

[Billing Account]

FROM

(biff, embedded labels, table is Account$)

in the main script. and this in the clean up script:

CleanUpMap:

mapping load * inline [

x, y

'LTD.', 'LIMITED'

'LTD', 'LIMITED'

];

LOAD Country,

[Corporate Account],

[Sales Account],

MapSubString('CleanUpMap',[Billing Account]) as [Billing Account]

FROM accountInfo

and this is not compiling as QLikView looks for the file accountInfo in the current folder.

Do you have an idea ?

Thanks

Re: Load from an existing QLikView table

Nicole-Smith — Mon, 30 Dec 2013 19:40:22 GMT

It should be RESIDENT accountinfo

Re: Load from an existing QLikView table

Mon, 30 Dec 2013 19:42:38 GMT

thanks for your time

but... this is not compiling either :

LOAD Country,

[Corporate Account],

[Sales Account],

MapSubString('CleanUpMap',[Billing Account]) as [Billing Account]

FROM RESIDENT accountInfo

Re: Load from an existing QLikView table

Nicole-Smith — Mon, 30 Dec 2013 20:02:45 GMT

LOAD Country,

[Corporate Account],

[Sales Account],

MapSubString('CleanUpMap',[Billing Account]) as [Billing Account]

RESIDENT accountInfo;

Re: Load from an existing QLikView table

Tue, 31 Dec 2013 20:47:48 GMT

You can use RESIDENT keyword to load existing internal tables. But if the tables are in huge, the RESIDENT is a bad idea. So please create intermediate TEMP qvd's and load from QVD's.

Re: Load from an existing QLikView table

preminqlik — Wed, 01 Jan 2014 04:53:36 GMT

hi find attachment

Re: Load from an existing QLikView table

Wed, 01 Jan 2014 06:02:15 GMT

you Can try with Apply Map Function.

ApplyMap('CleanUpMap',[Billing Account]) As [Billing Account],

but make sure your column name should be [Billing Account]into your inline mapping table instead of X & Y.

this method should work.

Re: Load from an existing QLikView table

Wed, 01 Jan 2014 17:04:20 GMT

use map function