Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to NoConcatenate two "loop load table"

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

;

3 Replies

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

Creator
Creator

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".

Not applicable

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


Thank you all.