Changing data column to data rows

[Anonymous]

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?

[Anonymous · Accepted solution]

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.

[Anonymous]

edit: I got it.. thanks for your help

[#4]

Hi,

I'm pretty curious to know your code.

Could you please show me what you have done.

Thanks

Regards

Giampiero

[#5]

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