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

Load fields containing a date

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

1 Reply
MarcoWedel