How to NoConcatenate two "loop load table"

[#1]

Hi, I've two table loaded by a loop.

Each table is loaded by a Concatenate in its loop, but I've to force the NoConcatenate from first table and second table

Any idea?

let Start=2015;

let Finish=2020;

//--- FIRST TABLE ---

for yy=$(Start) to $(Finish)

HoursTable:

  Concatenate

  LOAD

   '$(yy)' as [Year]

  ,[Hours] as [Hours]

  ,[Note]  as [HoursNote]

  FROM

  ['YEAR $(yy).xls'](biff, embedded labels, table is [HoursSheet$])

  ;

next

;

//--- SECOND TABLE ---

for yy=$(Start) to $(Finish)

MoneyTable:

  Concatenate

  LOAD

   '$(yy)' as [Year]

  ,[Money] as [Money]

  ,[Note]  as [MoneyNote]

  FROM

  ['YEAR $(yy).xls'](biff, embedded labels, table is [MoneySheet$])

  ;

next

;

[alexandros17]

a simple way is to add a fake field (something like '1' as myfield in only one of the load in this way there will be no concatenation ....

let me know

... then you cn drop the field

[geert_gelade]

You can just comment out the "concatenate" command in de for-next loop.

This will automatically create 2 separate tables, but linked in the datamodel on "Year".

[#4]

I think I'll use a fake field. This will make explicit the operation.

Thank you all.