Discussion board where members can get started with Qlik Sense.
I modified my script and I removed the last line, it was a mistake, I paste it on the wrong place.
so remove this (last line) and reload:
load Text(PARTNAME), iterno() as row, mid(Text(PARTNAME),IterNo(),1) As Letter;
yes!! it works!
thanks a lot!
I agree. I simply would prefer to learn how to do this in qlik.
but you are correct. it is much easier in MS Sql.
I've just redirected you to the right link. you should thank gwassenaar