Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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.

View solution in original post

7 Replies
Highlighted

Re: Load from an existing QLikView table

It should be RESIDENT accountinfo

Highlighted
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

Highlighted

Re: Load from an existing QLikView table

LOAD Country,

     [Corporate Account],

     [Sales Account],

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

RESIDENT accountInfo;

Highlighted
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.

Highlighted
Specialist II
Specialist II

Re: Load from an existing QLikView table

hi find attachment

Highlighted
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.

View solution in original post

Highlighted
Not applicable

Re: Load from an existing QLikView table

use map function