Joining/concatenating multiple fields into a table
Apologies if this is covered elsewhere but my forum trawling has not come up with much thus far
Not sure if I've described what I'm after properly in the title (it's my first time posting!) so I'll try to explain what I'm trying to do...:
I have a table (TableName9) that has separate data fields that I want to concatenate into 3 fields: Data_Type, Data_Delivery_Year, Data_Value.
The data type fields I want to combine into the field Data_Type are:
The delivery_year fields I want to combine into the field Data_Delivery_Year are:
The value fields I want to combine into the field Data_Value are:
And I want to combine them all into TableName11 so that all the data sit under the three fields (Data_Type, Data_Delivery_Year, Data_Value)
Only thing is...when I use the below code, the values are all there ....but the Data_Type and Data_Delivery_Year fields are only filled out for Contributions. The other data does not seem to be pulling through even though I thought it should by left joining on RowID.
Any help would be gratefully received and I'm happy to provide any further info as needed
Re: Joining/concatenating multiple fields into a table
I think you are missing an important detail. When you join qlik uses whatever common fields as the join condition so in your case probably only the first join for each type adds any values however I think you are not going to get the results you needed.
Are you looking to have fields where the values are a delimited list of the parts? This is what I think you are looking for.