topic Re: inline together with .xls in load statement? in QlikView

inline together with .xls in load statement?

Tue, 30 Dec 2014 17:59:14 GMT

Hi all!

First of all I really appriciate this community - fast and good help immediatelly! Thanks to you all!

To my question.

When I use Inline in a Load - is it not possible to use Inline together with data from an .xls-sheet in the same statment?

No matter how I try I can't include this Inline in my Load statement? Is it something crucial I am missing?

BR Tobias

Re: inline together with .xls in load statement?

shree909 — Tue, 30 Dec 2014 18:03:51 GMT

Hi i think u need to use concatenate .

Lonetable_TPL:

Load * inline [

Account Name,

lonekonte_TPL

];

concatenate(Lonetable_TPL)

load * from excel file;

Re: inline together with .xls in load statement?

andy_smith2005 — Tue, 30 Dec 2014 18:30:06 GMT

Tobias,

Arent you missing a simple Load statement after the Inline load has completed?? Also, Inline statement create data. Until they have completed you cannot apply any data changes such as ApplyMap - you can of course concatenate data together and use the ApplyMap function then

cheers

Re: inline together with .xls in load statement?

Tue, 30 Dec 2014 19:25:46 GMT

Hi there,

They are completely two separate tables so they should be treated that way.

Inline_Table:

Load * inline [

Account Name,

lonekonte_TPL

];

Excel_Table:

Load

@1 as FieldName1,

......

.....

ApplyMap(..........) as Field

From Excel ;

Make sure the Mapping table is loaded before the Excel_Table is being read and you should be good.

If you wanna append the two tables then you can use concatenate function as mentioned above.

Thanks