Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have data on the data load editor. When I click 'load data' it loads successfully. However, when I go to the UI, it cannot be found.
Does anyone know what need to be done to rectify this?
Best,
Alison
Hello!
You load your data with crosstable.
Then you load theses datas by resident.
The Name of the fields after crosstable and in resident statement are the same, so Qlik will concatenate them automatically.
So you drop your datas (and they are twice in your Project Budget table).
So add a
noconcatenate
in your script in line 17 before load
Regards
Maybe there's not fulfilled condition somewhere and it loads 0 rows?
Go to table viewer, your table shall be there. Only possible issue is that there is no data to load
Hi Alison,
can you give a screenshot of your problem
Beck
Do you have no data or just some of it is missing?
Can you share the load screen so I can see what it is doing?
Hi Alison,
Maybe there is drop table statement. Please check.
Thanks,
Arvind Patil
Hi,
In response to everyone's questions:
There it is in the data load editor,
But it doesn't show up.
Hello!
You load your data with crosstable.
Then you load theses datas by resident.
The Name of the fields after crosstable and in resident statement are the same, so Qlik will concatenate them automatically.
So you drop your datas (and they are twice in your Project Budget table).
So add a
noconcatenate
in your script in line 17 before load
Regards
Hi Martin,
Brilliant, this makes the fields show up in the UI!
However, there's still an issue. Project Budget includes the months Oct, Nov, Dec, Jan, Feb and March. Whereas, the data in Payments, Income, Expenditure and Overhead only include Jan, Feb and March.
In the UI, the field March only displays Jan, Feb and March, why is that>?
Thank you,
Alisom