Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
i need to write an expression in the script with the following output: when the field [@29:33] =35, the new field TIPO must show "ODONTO". The field [@29:33] is in table "D" while the field [@10:17] is the key between table "T" and "D".
I've tried with:
KEY_TO_UO_RIFERIMENTO:
Mapping LOAD
[@10:17] as CONTATORE_PRESCRIZIONE,
[@29:33] as UO_RIFERIMENTO
If(ApplyMap('KEY_TO_UO_RIFERIMENTO',[@10:17],'n/a')=35,'ODONTO') as TIPO
but don't work.
Can anyone help me?
Thanks,
Mattia
Sorry, Sunny, you're right.
Anyway, you've helped me, because while i'd creating a data sample file, i understand how to solve the problem!
I hope you can help me in the next topics.
Mattia
Don't see any issues... can you mock up the problem in a sample mocked up data for us to see?
Now it's difficult because i've a lot of data and i can't show them.
The script is the following:
KEY_TO_UO_RIFERIMENTO:
Mapping LOAD
[@10:17] as CONTATORE_PRESCRIZIONE,
[@29:33] as UO_RIFERIMENTO
FROM...
If(ApplyMap('KEY_TO_UO_RIFERIMENTO',[@10:17],'n/a')='35','ODONTO'),
If([@4:9]='001880','DIALISI', If(WildMatch([@10:17],'L*'),'LAB', If(Len(Trim([@10:17]))>0, If([@4:9]='030357','PS_AMB','AMB')))) as TIPO
After the reload, QV show me only "LAB" and "AMB" and i don't know why.
Also, between available fields, i've @10:17...
All I am asking for is to mock up 5-10 rows of data just like I did here What's wrong in this script? . If you are unable to do this... then I am cannot really spare time each time to create a mock up for you.
Best,
Sunny
P.S. Mock up doesn't need actual data... it can be data which doesn't make sense, but still shows the issue.
Sorry, Sunny, you're right.
Anyway, you've helped me, because while i'd creating a data sample file, i understand how to solve the problem!
I hope you can help me in the next topics.
Mattia