Replace String Value to Null

[sona_sa]

Hi,

I have 2 field. Area Name and Area Date. Area Name is 3 value - A, B, and C. Area Date has also three date - 29, 30 and 31

Now I want Where Area Name is B, Assign the null value in Area Date where 30 is available.

Please let me know how to do through QlikView script by Load statement.

Thanks

[sunny_talwar]

Now I want Where Area Name is B, Assign the null value in Area Date where 30 is available.

Assign null value in Area Date where 30 is available? What do you mean when you say 30 is available? can you support this with an example?

[sona_sa]

Hi Sunny,

Please find the attached xls. I need all data with G column.

Thanks.

[sunny_talwar]

What is the logic behind column G?

[sona_sa]

Means wherever In %DRQ_REQ_NAME_IS_WP_LinkKey Field value is RFKPI>>S7.5-MILESTONE, RACE_CHART_WEEK_DATE = ' ' Means Blank, Whatever value is there, It should be null.

Thanks

[sunny_talwar]

So, may be use WildMatch to search for the string RFKPI>>S7.5-MILESTONE

If(WildMatch(%DRQ_REQ_NAME_IS_WP_LinkKey, 'RFKPI>>S7.5-MILESTONE*'), Null(), RACE_CHART_WEEK_DATE) as RACE_CHART_WEEK_DATE_ OUTPUT

[sona_sa · Accepted solution]

While reloading

error is coming.

Thanks

[sunny_talwar]

Can you share the script you ran?

[sunny_talwar]

The error message response was the correct response? Really?