Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Changing data column to data rows

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
9191951BB5195151951951
9191951BB1959879879879
9191951BB9819819195195

I'd like it to show

NI numAccount 1Account 2Account 3
9191951BB519515195195119598798798799819819195195




Can anyone help?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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.

View solution in original post

4 Replies
Anonymous
Not applicable
Author

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
Not applicable
Author

edit: I got it.. thanks for your help

Not applicable
Author

Hi,

I'm pretty curious to know your code.

Could you please show me what you have done.

Thanks

Regards

Giampiero

Not applicable
Author

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