Data is not behaving properly

[smilingjohn]

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

[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]

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]

Hi Saran ,

PLease find the attachment of the qvw file

Thanks 

[Saravanan_Desingh · Accepted solution]

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, 
];