Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

priyarane
Contributor III

Synthetic table data only

Hi Community,

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

-Priya

7 Replies
arvind_patil
Valued Contributor II

Re: Synthetic table data only

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

roharoha
Valued Contributor III

Re: Synthetic table data only

why should you do that?

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

priyarane
Contributor III

Re: Synthetic table data only

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

roharoha
Valued Contributor III

Re: Synthetic table data only

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

Re: Synthetic table data only

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

roharoha
Valued Contributor III

Re: Synthetic table data only

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

willbleksem
New Contributor III

Re: Synthetic table data only

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.