Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

inline together with .xls in load statement?

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

example.png

1 Solution

Accepted Solutions
shree909
Partner
Partner

Hi i think u need to use concatenate .

Lonetable_TPL:

Load * inline [

  Account Name,

lonekonte_TPL

];

concatenate(Lonetable_TPL)

load * from excel file;

View solution in original post

3 Replies
shree909
Partner
Partner

Hi i think u need to use concatenate .

Lonetable_TPL:

Load * inline [

  Account Name,

lonekonte_TPL

];

concatenate(Lonetable_TPL)

load * from excel file;

View solution in original post

andy_smith2005
Partner
Partner

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

Not applicable
Author

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

AJ