topic Concatenate a specific cell value in another column in QlikView

Concatenate a specific cell value in another column

ferchops1987 — Fri, 27 Apr 2018 18:42:08 GMT

Hello,

I have the next table to record when a customer changes from one service to another one.

DDP_DATAALTA = Registration date

DTE_SERVEI_ANTIC = Old service

DTE_SERVEI_NOU = new service

DTE_DATA_MODIF = Modification date

I need to get the first service and the registration date in order to concatenate these values like this:

Finally I want to get something like this (concatenate the last two column with the first service (95) and the registration date as Start Date:

Start date	Service	Comments
05/07/04	95	This is the registration date and the first service from the column DTE_SERVEI_ANTIC.
23/09/08	1000076
16/05/14	118
12/02/15	1000076
19/03/15	118

Once I get this table, I will construct a period table.

I will appreciate so much your help. I tried to achieve this without success.

tomasz_tru — Sat, 28 Apr 2018 06:36:27 GMT

Could you translate this one question into english?

Tomasz

ferchops1987 — Sat, 28 Apr 2018 08:40:34 GMT

I’ve translated it! Thank you

tomasz_tru — Sun, 29 Apr 2018 07:37:23 GMT

I don't fully understand the desired output, but I would find first transaction on the SQL server side using OVER statement...