Skip to main content
Announcements
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Replace String Value to Null

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

1 Solution

Accepted Solutions
sona_sa
Creator II
Creator II
Author

While reloading

error is coming.

Thanks

View solution in original post

8 Replies
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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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?