I am trying to use this as a dimension but I am getting some duplicates where it shows both Project and Non-Project and not sure why:
=if(match(COM_CAT,'ERC - Project'),'Project','Non-Project')
I also tried is in the script but same issue: if(wildMatch("COMMITTEE_CAT",'ERC - Project')>0,'Project','Non-Project') as PROJECT
For this ticket, I would only expect Project since it did hit the ERC - Project status.
Mapping load DEFECT_ID,'Project' as To From Source where COMMITTEE_CAT='ERC - Project'
Load DEFECT_ID,Applymap('Project', DEFECT_ID,'Non-Project') as Project from Source
Do you have to use match?
Since there is only one string in your condition you could just do
if(COM_CAT = 'ERC - Project','Project','Non-Project')
perhaps you need to use trim(COM_CAT) there may be empty spaces around the text string.
‘I used an alias for COMMITTEE_CAT called COM_CAT’
Are you implementing the conditional statement in the same load statement as the alias is being created? In that case you would have to use the original name as the Alias is not applied in the load statement, or use a preload statement.
Joseph Eftamandilos | Consultant
DDI +353 1 272 7706 |Main +353 1 272 7700 Ext. 7706
email@example.com<mailto:firstname.lastname@example.org> | www.capventis.com<http://www.capventis.com/>
IRL: Building 4, Cherrywood Business Park, Dublin, D18 K7W4, Ireland
UK: 3rd Floor, 26 Finsbury Square, London EC2A 1DS, United Kingdom