Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am getting revered string from my system. For Example Item ABCD is loaded as DCBA.
Is there a function I can use to reverse the string, in the script itself?
Here is the script:
LIB CONNECT TO 'Sandra-Lavi (lavi_sandra)';
Parts:
LOAD
Text(PARTNAME) as Parts.PARTNAME ;
SQL SELECT
PARTNAME,
....
FROM lavi.dbo.PART;
Thanks !!
Sandra
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.
thanks!