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: 
smilingjohn
Specialist
Specialist

Data is not behaving properly

Hi All , 

Please refer my data screenshot below after loading the file  . now if you look  for the field FeatureID i have Empty and for the field Feature there is just a dash, 

How can I replace the dash (-) under Feature column by looking at the TeamID . Thanks

 

 

 

 

 

 

 

Thanks in Advance

1 Solution

Accepted Solutions
Saravanan_Desingh

Sorry I could not open your file. Because I am using PE. But please check the solution below.

tab1:
LOAD TeamID, FeatureID, If(Len(Trim(Feature))=0,Peek(Feature),Feature) As Feature;
LOAD * INLINE [
    TeamID, FeatureID, Feature
    5212700, REGRESSION, FE5318
    5212700, EMPTY, 
    50825165, TF1, FE496
    50825165, EMPTY, 
];

commQV35.PNG

View solution in original post

6 Replies
Saravanan_Desingh

The '-' seems to be NULL. So, you can check for the Null and replace it.

If(IsNull(Feature),'ReplaceMe',Feature)
Saravanan_Desingh

Oh sorry. I thought you will replace it with whatever you want.

If(IsNull(Feature),FeatureID,Feature)
smilingjohn
Specialist
Specialist
Author

Hi Saran, 

I want to replace the null value by the Feature number as shown in the screenshot below 

the highlighted blue mark should get filled up by the FEA53118 for TeamID  56441371075 and similarly 

and so on ....I hope I tried to explain . I know this is very complicated but need some help from you

 

 

 

 

Saravanan_Desingh

Oh I got it. Can you upload the sample file please?

smilingjohn
Specialist
Specialist
Author

Hi Saran ,

PLease find the attachment of the qvw file

 

Thanks 

Saravanan_Desingh

Sorry I could not open your file. Because I am using PE. But please check the solution below.

tab1:
LOAD TeamID, FeatureID, If(Len(Trim(Feature))=0,Peek(Feature),Feature) As Feature;
LOAD * INLINE [
    TeamID, FeatureID, Feature
    5212700, REGRESSION, FE5318
    5212700, EMPTY, 
    50825165, TF1, FE496
    50825165, EMPTY, 
];

commQV35.PNG