Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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