Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Hi Sunny,
Please find the attached xls. I need all data with G column.
Thanks.
What is the logic behind column G?
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
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
While reloading
error is coming.
Thanks
Can you share the script you ran?
The error message response was the correct response? Really?