Discussion board where members can get started with QlikView.
I would like to add a field to Table A based on the fourmula (IF(WeekDayNUmber = 3, 1,2), However WeekDayNumber is a field in Table B. Any advice on hwo best to go about thsi woudl be great. Please see the atatched test document.
Go to Solution.
A: LOAD DateActualFROMTest.xls(biff, embedded labels, table is A$);
B:LOAD DateActual, WeekdayNumber, DayOfMonthNumber, CYDayOfYearNumber, CYWeekOfYearNumber, CYMonthNumber, [CY Quarter], [CY Year], [CY Year Month], [CY Year Month Name], [CY Year Month Short], [CY Year Quarter], FYDayOfYearNumber, FYWeekOfYearNumber, FYMonthNumber, [FY Quarter], [FY Year], [FY Year Month], [FY Year Month Name], [FY Year Month Short], [FY Year Quarter], [Out of Hours]FROMTest.xls(biff, embedded labels, table is B$);
Load DateActual,WeekdayNumber as WeekdayNumber1resident B;
if(WeekdayNumber1=3,1,2) as Flagresident A;
drop table A;
for the reply. WOuld this be the same if i were loading my tables from MS Access? It does not seem to like :
sorry it does work. thanks