Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

jidgensean
New Contributor III

2 Excel spreadsheets with different fields into 1 qvd

I have seen some conversation around this topic but I cannot wrap my head around it.

Excel file 1

Requests:

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.

thx

jude

1 Reply
effinty2112
Honored Contributor

Re: 2 Excel spreadsheets with different fields into 1 qvd

Hi Judy,

Try:

Requests:

Load Id, Request#, RequestDescription, Detail Status.....etc

Concatenate(Requests)

Load Number, Request#, RequestDesc, Status.....etc.

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:

Concatenate(Requests)

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.

Regards

Andrew