Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
oskorn29
Contributor
Contributor

Help with oracle data loading

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

Labels (1)
1 Reply
m_woolf
Master II
Master II

Something like this:

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

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