Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
A customer maintains an annual workday calendar data in a .csv file. The file contains each date of the year and a code that represents each day as either a weekday, weekend, or holiday.
A developer loads the file directly into QlikView and attempts to join it onto the master calendar table.
The master calendar table contains calendar data for the same time period as the customer's calendar, using the field Date from each table as the key.
The resulting table contains multiple instances of each date and the Day Type field has no effect on the pre-existing data.
How should the developer correct the join?
>use the Date() function to format the key fields as dates with the same form
>use the Upper() function to format the date as string with the same form
>use the String() function to format the key fields as strings
>change Join to Left Join to eliminate the multiple instances
First option should be most appropriate because, though the values in the fields might be same, but the QV is reading it as a string.