Qualified Form Column Line

[RafaelStaub]

Good morning everyone,

I am trying to dynamically turn some records into columns, as adding more records Scrip turns them into columns, as shown in the example below.

I want to do exactly this transformation that is demonstrated in print.

Currently my script looks like this:

AgendaGoogle:
LOAD Distinct
Mês As 'Competencia',
Data As 'Data' ,
[Nome do Funcionario] As 'Consultor'
FROM [lib://Transformados Painel de Serviço (toccato_rafael.staub)/Agenda.qvd](qvd);

//For RecNo() to RowNo()
For x = 0 to 5
Concatenate(AgendaGoogle)
generic Load
"Nome do Funcionario" As '$(Peek(Distinct [Nome do Funcionario], x))'
FROM [lib://Transformados Painel de Serviço (toccato_rafael.staub)/Agenda.qvd](qvd);

Next;

Exit Script;

and the following error is displayed:

The following errors occurred:
Illegal combination of prefixes

The error occurred here:
Concatenate (AgendaGoogle) generic Load "Employee Name" As '' FROM [lib: // Transformed Service Panel (toccato_rafael.staub) /Agenda.qvd] (qvd)

Can anyone help me with this case?

[Gysbert_Wassenaar · Accepted solution]

You can't use concatenate and generic together. Leave out the concatenate if you want to generate the generic tables. If you want one result table then you need to join the generic tables together, not concatenate them.

Better yet, don't do a generic load at all, but use a pivot table object in the front end as visualisation