topic Re: Changing data column to data rows in QlikView

Changing data column to data rows

Anonymous — Mon, 04 Feb 2013 10:27:31 GMT

I've set this discussion up again as I feel i was not clear enough the first time.

Here's what i've got at the moment, it's fairly simple code

Directory;

LOAD Account,Nationalins,email

FROM

[..\File.DAT]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

This shows

Ni num	Account num
9191951BB	5195151951951
9191951BB	1959879879879
9191951BB	9819819195195

I'd like it to show

NI num	Account 1	Account 2	Account 3
9191951BB	5195151951951	1959879879879	9819819195195

Can anyone help?

Re: Changing data column to data rows

Anonymous — Mon, 04 Feb 2013 11:08:22 GMT

Try using Concat() to create a string of account numbers with a semi colon separator for example, over each NI num and then apply subfield() on this to split them in different fields.

Re: Changing data column to data rows

Anonymous — Mon, 04 Feb 2013 11:24:46 GMT

edit: I got it.. thanks for your help

Re: Changing data column to data rows

Mon, 04 Feb 2013 12:00:16 GMT

Hi,

I'm pretty curious to know your code.

Could you please show me what you have done.

Thanks

Regards

Giampiero

Re: Changing data column to data rows

Mon, 04 Feb 2013 13:19:06 GMT

Hi,

I'm sorry if I'm asking that but I'd like to know how you solved the dynamic number of account numbers.

In your example you have three different account for one Ni numnber.

So you create three different expression with subfield() function.

But if you don't know how many account number you have?

It's an interesting post that I'd like to go through just to improve my knowledge of QlikView.

Hope Johannes can help me with this question.

Best regards

Giampiero