new dimension in load script

[DominiC181]

Hi everyone, I need help with the issue below.

I would like to create a new dimension from another in the load script.

I have a dimension called Accounts (consists of six digits)

Now I need to choose only a few accounts from this dimension and create a new dimension called AcctypeMAa

For example all 521xx1 and all 524xx1 accounts.

So in new dimension will be accounts like 521451, 524781 and so on.

How can i do it in load script?

 And what if the dimension was stored as text? How to create?

Thanks for any help.

[rwunderlich · Accepted solution]

if(Wildmatch(account, '521??1', '524??1'),  account, null()) as AcctypeMAa

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[DominiC181]

Dear Rob,

works great.

Thank you very much 🙂