Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
DanielReed
Contributor
Contributor

Field name different across 2 files

Hi, i need some help.

I am trying to load a few files into QV, but in some of the files somebody hasn't been consistent with the naming of fields - for example, 'REMARKS' in one file, 'Remarks' in another.

When i try to load all files, i wan't QV to recognise that they are both the same regardless of the difference. I know i can load with no headers (load as A, B, C etc) but that would mean i would need to be certain that i have the same number of columns in each file.

I have tried the ALIAS function, but i am either using it wrong or misunderstand its use...

Any help would be greatly appreciated!

Thanks in advance,

Dan

1 Reply
Brett_Bleess
Support (Former)
Support (Former)

Hopefully the following Design Blog post is what you need:

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.