topic new dimension in load script in App Development

new dimension in load script

DominiC181 — Sun, 30 Jan 2022 18:19:35 GMT

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 — Sun, 30 Jan 2022 19:56:45 GMT

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

DominiC181 — Wed, 16 Feb 2022 14:18:38 GMT

Dear Rob,

works great.

Thank you very much 🙂