topic Re: Keep by columns in QlikView

Keep by columns

jplozano — Thu, 25 Oct 2018 11:07:04 GMT

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

Re: Keep by columns

kingsley101 — Thu, 25 Oct 2018 11:39:51 GMT

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

Re: Keep by columns

jplozano — Thu, 25 Oct 2018 11:49:45 GMT

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

Re: Keep by columns

kingsley101 — Thu, 25 Oct 2018 12:02:39 GMT

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

Re: Keep by columns

jplozano — Thu, 25 Oct 2018 12:07:10 GMT

I will try this!!

Thanks