Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Wats wrong with the below syntax, I want to use If and Name l beginning from A90 or D90 or P90. But below script doesnt work.
AutoNumberHash128(IF([Name] like 'A90*', IF([Name] like 'P90*',If([Name] like 'D90*',([Part] &'-' & FLOOR(Date([Schedule ]))))))) AS DT_KEY
Any inputs?
If(Wildmatch(Name, 'A90*','P90*','D90*'),AutonumberHash128(Part, Floor([Schedule ]))
could work, if you only want to generate key values for distinct combinations of Part and Schedule days if Name starts with A90, D90 or P90.
hope this helps
regards
Marco
I think this will like ... beginning from A90 AND D90 AND P90 which obviously doesn't work.
Try Wildmatch() instead:
AutonumberHash128( If( Wildmatch([Name],'P90*','D90*','A90*'), [Part] &'-' & FLOOR(Date([Schedule ])) ) AS ...
If(Wildmatch(Name, 'A90*','P90*','D90*'),AutonumberHash128(Part, Floor([Schedule ]))
could work, if you only want to generate key values for distinct combinations of Part and Schedule days if Name starts with A90, D90 or P90.
hope this helps
regards
Marco