I'm new to the Qlikview tool and currently working from datas extracted directly from the Oracle JDE database.
I would like to know is there a way to remove periods from field value.
Transform 50250.2041.503 to 502502041503
Thanks in advance!!
=replace( '50250.2041.503', '.', '')
But I would like to know how can I apply it to the whole field.
Thank you, again.
REPLACE([FieldName],'.','') AS FieldName
same answer, just use the field
replace (field, '.', '') as newfield;
Try below in script
replace( YourFieldName, '.', '') as YourFieldName
purgechar(YourFieldName, '.') as YourFieldName
Retrieving data ...