Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Load from an existing QLikView table

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

1 Solution

Accepted Solutions
Not applicable

Re: Load from an existing QLikView table

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.

7 Replies

Re: Load from an existing QLikView table

It should be RESIDENT accountinfo

Not applicable

Re: Load from an existing QLikView table

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

LOAD Country,

     [Corporate Account],

     [Sales Account],

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

RESIDENT accountInfo;

Not applicable

Re: Load from an existing QLikView table

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
Valued Contributor II

Re: Load from an existing QLikView table

hi find attachment

Not applicable

Re: Load from an existing QLikView table

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.

Not applicable

Re: Load from an existing QLikView table

use map function