topic Re: Snapshot, Concatenate, Date in App Development

Snapshot, Concatenate, Date

zazaci — Fri, 22 Oct 2021 08:51:28 GMT

Hello everybody,

For each customer, I would like to keep the history of their telephone number for 12 months, for example. To do this, I created 12 different qvds that contain customer info for each month.
But I want to display in a table each field in a column with the corresponding month as the example below:

In my script, I concatenate the 12 qvd but since I have 12 different dates, I would like them in a single field to create a single date filter in my dashboard.
Would you know how I can do this please?

Thank you in advance for your answers.

Re: Snapshot, Concatenate, Date

zazaci — Fri, 22 Oct 2021 09:01:09 GMT

Also I concatenate 12 tables with the same key by renaming each field since I only want one for each month

Ex:

Customer:

LOAD
key,

Date1,
Num as Num1

From QVD1

Concatenate

LOAD
key,

Date2,
Num as Num2
From QVD2

Concatenate

LOAD
key,

Date3,
Num as Num3
From QVD3

.
.
.
.
.