inline together with .xls in load statement?

[#1]

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

[shree909 · Accepted solution]

Hi i think u need to use concatenate .

Lonetable_TPL:

Load * inline [

  Account Name,

lonekonte_TPL

];

concatenate(Lonetable_TPL)

load * from excel file;

[andy_smith2005]

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

[#4]

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