Discussion Board for collaboration related to QlikView App Development.
I have seen some conversation around this topic but I cannot wrap my head around it.
Excel file 1
Load Id, Request#, RequestDescription, Detail Status.....etc
Excel File 2
Load Number, Request#, RequestDesc, Status.....etc.
I cannot get the concatenate to work & I'm not sure if that is what I want to use (newbie). I want all the fields from both spreadsheets saved to a qvd.
Please someone show me the format of how to accomplish this.
Without the Concatenate statement the tables won't auto concatenate because the fields are not named identically in the two load statements.
If the fields RequestDescription from the first excel file means the same thing as RequestDesc in the second it would be good to change the name to match. Maybe:
Load Number as [Load Id], Request#, RequestDesc as RequestDescription, Status as [Detail Status],.....etc.
If you force concatenation and the field names don't match the data will be split into two seperate fields in the data model.
Now you can create your qvd from the table Requests.