topic Re: concatenate duplicate field. in QlikView

concatenate duplicate field.

Anonymous — Wed, 20 Jun 2012 17:35:17 GMT

Does anyone know how to do this?

I need to group the repeated line as shown below.

LOAD

* INLINE [
FORNECEDOR, GRUPO, PRODUTO, VEICULO
320, 310, 11, FIAT
320, 310, 11, CHEVR
320, 310, 13, FORD
]

;

Wed, 20 Jun 2012 18:51:11 GMT

Hi,

you can create a straight table with dimension "Fornecedor", "Grupo" and "Produto"

create a expression:

CONCAT(VEICULO, ',');

Anonymous — Wed, 20 Jun 2012 19:07:17 GMT

Is there any way to do this function within the scipt?

Wed, 20 Jun 2012 19:11:40 GMT

LOAD

FORNECEDOR,

GRUPO,

PRODUTO,

CONCAT(VEICULO, ',') AS VEIC

INLINE [

FORNECEDOR, GRUPO, PRODUTO, VEICULO

320, 310, 11, FIAT

320, 310, 11, CHEVR

320, 310, 13, FORD

]

GROUP BY FORNECEDOR,

GRUPO,

PRODUTO;

Anonymous — Wed, 20 Jun 2012 20:00:00 GMT

Beauty, solved the problem, thanks.

Jason_Michaelides — Wed, 20 Jun 2012 22:50:30 GMT

Please make sure you mark a correct answer so it closes the thread.

Thanks,

Jason