how to add condition in existing 'dual'

[#1]

Hi,

I have below script in qvw

LOAD *,

          Dual('ASD Workout',5) as Outnew

Resident Worktable

Where MixMatch([Group],
'dataout',
'trei',
'poiu',
'read');

I have used Outnew in piovot table as dimension. now I have to add condition to existing Outnew.
below is the condition

Outnew+0.4*'datain'

please can antone suggest me how to add the above condition in dual script?

Thanks.

[MK_QSL]

Provide sample file!

[Peter_Cammaert]

In your existing load, Outnew is a field that contains dual('ASD Workout', 5) for all rows.

And you want to change this into what?

Outnew+0.4*'datain'

• is not a condition,
• tries to multiply a string by 0.4 which is not possible (it will produce NULL),
• and uses Outnew which doesn't exist as you are creating it.

You understand that I'm not following all too well. Can you enlighten me a bit? Thanks.

P.

[#4]

Thanks. please see attached.