Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
jplozano
New 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
New Contributor III

Re: Keep by columns

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
New Contributor

Re: Keep by columns

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

kingsley101
New Contributor III

Re: Keep by columns

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
New Contributor

Re: Keep by columns

I will try this!!

Thanks