Qualified Form Column Line

RafaelStaub — Fri, 27 Sep 2019 12:24:35 GMT

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?

Re: Qualified Form Column Line

Gysbert_Wassenaar — Fri, 27 Sep 2019 13:56:51 GMT

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

topic Re: Qualified Form Column Line in App Development

Qualified Form Column Line

Re: Qualified Form Column Line