Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I need to load all files starting with XXX.
I usually just load all files regardless of the name (see below)
but how do I load the files starting with XXX only?
FROM
(
LOAD *
FROM
LOAD *
FROM
(ooxml, embedded labels, table is Sheet1);
Hi,
Please try the following
FROM
(
Regards,
Joshmi
Wild card characters are very help full when doing are including matching pattern or style of input.
Ex: *XXX.xls allows Any string in place of astrict i.e '*'
Wild card Entry Allowed format of Date
*XXX.xls hai123XXX.xls
XXX*.xls XXXhai123.xls
*XXX*.xls hai123XXXhai123.xls
*.xls Loads all .xls files
Note: Here i am using hai123 in place of *, actually it will allows any value in place of astric