topic Re: Field values don't appear in QlikView

Field values don't appear

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I need help with a project I'm busy with. There's about 5 tables I have to concatenate to create one full database.

The problem that occurred is whenever i'm finished running the scripts, theres one particular field that wont appear. That field is important as it gives a specific description of the ongoing fields and tables.

Re: Field values don't appear

MarcoWedel — Thu, 19 Oct 2017 21:21:34 GMT

Hard to tell without knowing your tables and script.

Maybe this helps:

Qlik Community Tip: Posting Successful Discussion Threads

How to get answers to your post?

Its not about the answer, rather it’s about the question…

regards

Marco

Re: Field values don't appear

Sokkorn — Fri, 20 Oct 2017 01:53:50 GMT

Hi Ervin,

I would suggest to check in your script is there any "DROP Field" keyword. Moreover, you may check if the field exist in your database.

Can you share your load script?

Sokkorn

Re: Field values don't appear

madhumitha — Fri, 20 Oct 2017 04:57:14 GMT

Hello Ervin,

Are you force concatenating or Auto concatenating?

There is a good possibility that you miss a table itself if you auto concatenate without matching fields.

Try using debug/exist script in loading steps and find out where exactly you are dropping the field.

Also please post your script so that we can have a clear idea.

Thanks!

Re: Field values don't appear

mithilesh17 — Fri, 20 Oct 2017 05:25:46 GMT

Dear Ervin,

It seems you are not taking that particular field in your load script. Do check that first!

Regards,