This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
(biff, embedded labels, table is Account$)
in the main script. and this in the clean up script:
mapping load * inline [
MapSubString('CleanUpMap',[Billing Account]) as [Billing Account]
and this is not compiling as QLikView looks for the file accountInfo in the current folder.
Do you have an idea ?
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
It should be RESIDENT accountinfo
thanks for your time
but... this is not compiling either :
FROM RESIDENT accountInfo
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.
hi find attachment
use map function