topic Re: Synthetic table data only in QlikView

Synthetic table data only

priyarane — Tue, 04 Jul 2017 09:38:35 GMT

Hi Community,

Is there any way to export fields from only synthetic table only.

-Priya

arvind_patil — Tue, 04 Jul 2017 09:55:00 GMT

Hi Priya,

You cant export fields from synthetic table . It is Virtual table just for visualization.

You can take table box and take all those common fields and export it.

Thanks,

Arvind patil

Anonymous — Tue, 04 Jul 2017 09:55:33 GMT

why should you do that?

Just build a link table manually and save it...

priyarane — Tue, 04 Jul 2017 10:04:37 GMT

we need to understand that how many fields are common between 2 tables or many then will take some decission

Anonymous — Tue, 04 Jul 2017 10:08:32 GMT

TABLE:1

LOAD

X as $KEY1,

X as X_LOCAL

------------------------

TABLE:2

LOAD

Y as $KEY1,

Y as Y_LOCAL

--> then put for example Y_LOCAL, X_LOCAL and $KEY into a table box and then you see what Keys are common...

priyarane — Tue, 04 Jul 2017 10:22:33 GMT

BEFORE LOADING WE DON'T KNOW HOW FIELDS ARE COMMON.

Anonymous — Tue, 04 Jul 2017 11:01:02 GMT

ok, you LOAD unclear data into QlikView and try to export the syntethic link tables for clarifying which fields to rename?!?

Anonymous — Wed, 05 Jul 2017 13:29:34 GMT

Hi Priya,

On your Qlikview document press CTRL + T. This would show you the Qlikview tables and their relationships.

the Syn key table will show you all the fields which are duplicated or looped many times.