Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to load a table whose field names contain a date.
There are 24 fields whith date which gives the history of the last 2 years.
The name of the table contains the max date : table_201808
data:
Load
"Code EAN" as "Code CIP 13",
"Laboratoire (constant)",
"UN 09/2016",
"UN 10/2016",
"UN 11/2016",
"UN 12/2016",
"UN 01/2017",
"UN 02/2017",
"UN 03/2017",
"UN 04/2017",
"UN 05/2017",
"UN 06/2017",
"UN 07/2017",
"UN 08/2017",
"UN 09/2017",
"UN 10/2017",
"UN 11/2017",
"UN 12/2017",
"UN 01/2018",
"UN 02/2018",
"UN 03/2018",
"UN 04/2018",
"UN 05/2018",
"UN 06/2018",
"UN 07/2018",
"UN 08/2018",
FROM table_201808;
Thank you for your help
Johanna
see also: