I am quite new with QV. I have the following situation where the BusinessDates_temp.BusinessDate is not recognised by QV. It used to be like the below but I don't want to hardcode to one date PositionDate, I need a join of all possible Date values from SMI_Collateral. I guess I am trying to make it look like SQL! Any ideas how it should be done?
date($(PositionDate),'DD-MM-YYYY')as %Key_BusinessDate, &'_'& %Key_AccountCode as %Key_BusinessDate_AccountCode
The explicit Join prefix can be preceded by the prefix outer in order to specify an outer join. In an outer join all combinations between the two tables are generated. The resulting table will thus contain combinations of field values from the raw data tables where the linking field values are represented in one or both tables. The outer keyword is optional.
The names in Qlikview are not the same as SQL. These two fields
are not related in any way - note the square brackets. These are not qualified names as in SQL, they are just different names. And QV field names are case sensitive, so FieldA and fielda are different fields.
OK let me rephrase it then. I have 2 tables A, B and they are linked with column C3. I would like to produce a join between the two tables where one resulting column will be the concatenation of A.Col1 and B.Col2 . Is that possible or do I need to save into a table and get the concatenation from a second separate step. Thanks!