2 Excel spreadsheets with different fields into 1 qvd

Anonymous — Fri, 20 Oct 2017 19:16:49 GMT

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

Re: 2 Excel spreadsheets with different fields into 1 qvd

effinty2112 — Sat, 21 Oct 2017 09:02:27 GMT

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

topic 2 Excel spreadsheets with different fields into 1 qvd in QlikView

2 Excel spreadsheets with different fields into 1 qvd

Re: 2 Excel spreadsheets with different fields into 1 qvd