Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
];
The '-' seems to be NULL. So, you can check for the Null and replace it.
If(IsNull(Feature),'ReplaceMe',Feature)
Oh sorry. I thought you will replace it with whatever you want.
If(IsNull(Feature),FeatureID,Feature)
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
Oh I got it. Can you upload the sample file please?
Hi Saran ,
PLease find the attachment of the qvw file
Thanks
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,
];