QlikView App Dev

[#1]

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

[Nicole-Smith]

It should be RESIDENT accountinfo

[#3]

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

[Nicole-Smith]

LOAD Country,

     [Corporate Account],

     [Sales Account],

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

RESIDENT accountInfo;

[#5]

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.

[preminqlik]

hi find attachment

[#7 · Accepted solution]

Hi

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.

[#8]

use map function