Discussion Board for collaboration related to QlikView App Development.
i have a requirement :
I have below data:
now the values in colfield2 should be replaced with none ,
how to do that
Can you try
Purgechar(field2,'0123456789:') as newField
now the values in colfield2 should be replaced with NULL,
On what condition it should be null?
Null() as field2
Null() as FieldName OR
'' as FieldName
Not sure 100% i followed you?
Mapping Load None , Null() autogenerate 1;
Map subfield(Field2,':',2) using NullTable;
should be loaded before your original table...
filed2 displays value in above format against field1
so field 2 values should be null