Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jplozano
Contributor
Contributor

Keep by columns

Hi everyone!

I´m triying to connect multiple tables in a qlikSense App.

First, i store all data in qvd´s in 4 different apps. After that, I want to connect all tables, but the main data is from table3.

My model is similar to this:

Table1    ------- Table3-------Table4---------Table5

Table 2                                                     Table6

Table3 and Table4 are connected to two dimensions and Table3 and Table4 are facts tables.

When I make the Keep sentence, my data connect by multiple fields because the fields name are the same in some table, but the information is different.

Is possible to specify the column name in the keep sentence?

Is there any other possibility to do this?

Thanks and regards

4 Replies
kingsley101
Contributor III
Contributor III

Hi Javier.

Keep won't be too helpful in your case.

Can you just rename the fields that you don't want connecting to another table so that they don't associate with the table?

Thanks

jplozano
Contributor
Contributor
Author

Keep sentence associate by field name or alias? I can change the field alias but i dont know if that will work

kingsley101
Contributor III
Contributor III

Hi Javier.

Yes, change the output field name: ie. Loaded_FieldName as abcFieldName.

This will make the field name unique and therefore won't create many associations

Thanks

jplozano
Contributor
Contributor
Author

I will try this!!

Thanks