Keep by columns

[jplozano]

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

[kingsley101]

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]

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

[kingsley101]

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]

I will try this!!

Thanks