Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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
Nicole-Smith

It should be RESIDENT accountinfo

Not applicable
Author

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;

Not applicable
Author

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
Specialist II
Specialist II

hi find attachment

Not applicable
Author

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

Not applicable
Author

use map function