Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Hope this find the right person who can help me out
Source data: Text files which are generated automatically and can vary from 10-15 in number and will be dropped in to folder
Qlik View Application: We have created an application based on a standard source which contains set of 11 fields and relevant expressions based on this 11 fields in the front end , so the application is freezed
Issue : some times the source may not contain all the 11 fields and the data can have 8-9 fields,In that case I don't want to change the code in the Qlik View application and set the non available field values as 0
Ex: standard source data
Code | emp | sale | qty | sale type | model | Region | country | state | reporting | Month |
---|---|---|---|---|---|---|---|---|---|---|
2345 | Anand | laptop | 5 | Online | L-4567yh | Asia | India | Andhra pradesh | Sindhu | January |
5867 | Arun | desktop | 8 | Vendor | D-2456t | Asia | India | Karnataka | Sindhu | January |
8954 | Ajay | laptop | 4 | Institution | L-4567y | Asia | India | Uttar pradesh | Sindhu | January |
4698 | santosh | Mobile | 6 | Retail Outlet | insol-2 | Asia | India | Kerela | Sindhu | January |
6457 | Surya | Tablet | 2 | Online | 345ikte | Asia | India | Orissa | Sindhu | January |
Faulty Source data:
Code | emp | sale | qty | sale type | model | Region | Month |
---|---|---|---|---|---|---|---|
2345 | Anand | laptop | 5 | Online | L-4567yh | Asia | January |
5867 | Arun | desktop | 8 | Vendor | D-2456t | Asia | January |
8954 | Ajay | laptop | 4 | Institution | L-4567y | Asia | January |
4698 | santosh | Mobile | 6 | Retail Outlet | insol-2 | Asia | January |
6457 | Surya | Tablet | 2 | Online | 345ikte | Asia | January |
Now in the faulty source data , fields Region, country, state , reporting are not available
So if i Load the Qlik view application it will throw an error as field not found so inspite of that error I want to load the application as is with a dummy value like 0 in to that field .
Thanks ahead.
Anand.
Hi Anand,
It sounds like you are viewing the thread in your Activity & Inbox section of your profile, because there are not as many options there. You will need to click on the thread title link to view the actual thread in the community in order to see the Correct Answer button.
Here is a direct link to this thread: Set a dummy value to fields if not present in the source
Please let me know if you are still having trouble.
Best,
Qlik Community Team
That helped Jeremy, Thank you
Hi Anand,
Thanks for marking my answer as correct. I appreciate your efforts to do that (and thanks to Jeremy too).
All the best and happy Qliking!
Andrew