Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

requirement

i have a requirement :

I have below data:

   

field1field2
123123:None
456456:None
345345:None

now the values in colfield2 should be replaced with none ,

how to do that

20 Replies
Anonymous
Not applicable
Author

Can you try

Purgechar(field2,'0123456789:') as newField

antoniotiman
Master III
Master III

SubField(field2,':',-1)

Anonymous
Not applicable
Author

i have a requirement :

I have below data:

   

field1field2
123123:None
456456:None
345345:None

now the values in colfield2 should be replaced with NULL,

how to do that

Anonymous
Not applicable
Author

On what condition it should be null?

prashantsanchet
Creator
Creator

SubField(field2,':',-1)

antoniotiman
Master III
Master III

Null() as field2

Anil_Babu_Samineni

Simply

Null() as FieldName OR

'' as FieldName

Not sure 100% i followed you?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

try this,,,

NullTable:

Mapping Load None , Null() autogenerate 1;

Map subfield(Field2,':',2) using NullTable;

should be loaded before your original table...

Anonymous
Not applicable
Author

filed2 displays value in above format against field1

so field 2 values should be null