Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
need to load the below from multiple Excel files.
Some sort of FOR EACH File scripting, but cannot seem to get it right.
Any suggestions?
Kind Regards,
Olle
Tbl:
LOAD currency,
[account no.],
CTPY,
[value date],
[CR/DR],
amount,
status,
reference,
type,
ProcessDate,
ProcessTime,
1 As Key
FROM
[sampleDateTime.xls]
(biff, embedded labels, header is 2 lines, table is dateTime$);
Join(Tbl)
LOAD Date(@1) As Date,
Time(@2) As Time,
1 As Key
FROM
[sampleDateTime.xls]
(biff, no labels, header is 1 lines, table is dateTime$) Where RecNo() < 2;
Hi Olle,
Still cleaning the data, huh?
See the app attached.
And see documentation for "Enable transformation step"
Regards,
David
Thanks, tried to apply this example earlier today but Im too much of a noob im afraid
Did not manage to make it work properly
try the attached file. there are two variables that need to be set to your folder paths - one for the path with xls files and the other with path to where the qvd files need to be saved...good luck.
Looks great! Thanks a lot!
Can you pls have a look at the attached though. Seem to be missing out on something when trying to apply your code. Something with the paths maybe? Or is it the folder structure?
Thanks in advance,
Olle !
Hi Olle,
Still cleaning the data, huh?
See the app attached.
And see documentation for "Enable transformation step"
Regards,
David
Haha, you know it David!
Never ending cleaning story this one.
But your help is useful as always, thanks a lot!!