Help with oracle data loading

oskorn29 — Sat, 16 Nov 2024 04:26:53 GMT

good morning

I'm connected to an oracle database, however the table I need to use is associated with the date, that is:

the name of the table today is A190214, the day will be generated tomorrow the table A190215 and so on

There is some way to generate a type of wildcard so that you can use the table all existing tables with associated date, without having to manually load by table

regards

Re: Help with oracle data loading

m_woolf — Thu, 14 Feb 2019 16:20:49 GMT

Something like this:

let vDate = right(year(today()),2) & num(month(today()),'00') & num(day(today()),'00');

load .....from A($(vDate);

topic Re: Help with oracle data loading in QlikView

Help with oracle data loading

Re: Help with oracle data loading