Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to flag certain days to for all Employees to Status = 1.
My Qvd now looks like this(without Employee information) with only Status and WDIDate.
What I want is to add _MappedStatus with current Status-values, but with status-value set to 1 on certain dates.
On WDIDate like '20180521', I want _MappedStatus = 1 (as shown in .xlsx extract in the bottom of the post)
To map certain values based on Datefield I have created a map table as xlsx.
I've tried some sort of ApplyMaps, but that just gives me the orignial values as shown in the first picture.
Any suggestions is well appreciated.
Thanks in advance!
/Henrik
Hi,
Make sure that the fields you are mapping have the same field type e.g Date mapping to a Date column or else make them both text and try then
Hi,
Make sure that the fields you are mapping have the same field type e.g Date mapping to a Date column or else make them both text and try then