Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Not Found On UI

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

1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

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

View solution in original post

8 Replies
tomasz_tru
Specialist
Specialist

Maybe there's not fulfilled condition somewhere and it loads 0 rows?

Anonymous
Not applicable
Author

Go to table viewer, your table shall be there. Only possible issue is that there is no data to load

beck_bakytbek
Master
Master

Hi Alison,

can you give a screenshot of your problem

Beck

rittermd
Master
Master

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?

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Alison,

Maybe there is drop table statement. Please check.

Thanks,

Arvind Patil

Not applicable
Author

Hi,

In response to everyone's questions:

There it is in the data load editor, 

Screenshot (48).png

But it doesn't show up.

Screenshot (47).png

martinpohl
Partner - Master
Partner - Master

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

Not applicable
Author

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