Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Synthetic table data only

Hi Community,

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

-Priya

7 Replies
arvind_patil
Partner
Partner

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
Not applicable

why should you do that?

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

priyarane
Specialist
Specialist
Author

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

Anonymous
Not applicable

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
Specialist
Specialist
Author

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

Anonymous
Not applicable

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

willbleksem
Contributor III
Contributor III

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.