Load fields containing a date

Anonymous — Thu, 18 Oct 2018 07:51:37 GMT

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

Re: Load fields containing a date

MarcoWedel — Thu, 18 Oct 2018 19:47:21 GMT