topic Re: How to NoConcatenate two "loop load table" in QlikView

How to NoConcatenate two "loop load table"

Thu, 02 Oct 2014 15:27:43 GMT

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$])

;

//--- 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$])

;

alexandros17 — Thu, 02 Oct 2014 15:37:10 GMT

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 — Thu, 02 Oct 2014 17:35:21 GMT

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

Fri, 03 Oct 2014 07:06:25 GMT

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

Thank you all.