Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (2)
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);