that was what i've been looking for. Thank you!
How would be the script command for combining several logical expression for e.g. the rule: show me cells that are >7 and <7? So everything that hasn't got 7 numerical digits can be identified (even blank fields or zero) via Status.
I can't tell why this didn't work:
But i figured out that the following command lines did the job:
Load if(len(Kundennummer)<>7, 'ERROR', 'OK') as Status,
FROM [lib://DQM/20150925_Auszug DQM-Sicht.xls]
(biff, embedded labels, table is [owssvr (9)$]);
It worked like: show me ERROR, if a cell has more or less than 7 digits. Almost like show me ERROR, if a cell is unequal 7 digits. Is there a dedicated syntax command for unequal? Like =! 7 or =/= 7? Or ist it simply <>?
To make it even more simple:
How is the Syntax command for: Show 'ERROR', if a cell has not 7 digits or is blank?