Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
;
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
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".
I think I'll use a fake field. This will make explicit the operation.
Thank you all.