Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

incorrect fields names order (loading from mdb table)

Hi all!

Using Qlik Sense I am confronted by things very mysterious. I have OLE connection to a dataset .mdb. Thats ok exept one thing - names of fields in dataset are defined incorrectly (for some reason they define in alphabetic order)- so field names dont mach with a content. Of course, its availible to reorder names manually, but it looks like very tiresome. Does anybody know how to correct that automatically?

Thanks a lot! Marina.

2 Replies
marcus_sommer
MVP
MVP

I assume this is a feature from oledb-driver but within qlik the order from fields isn't important. Neither within the datamodel nor by joins/concatenate within the script.

- Marcus

Not applicable
Author

I see, thanks a lot!!!