Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sagaraperera
New Contributor III

want to remove "$SYN_1" in Qlickview program.

when i'm try to connect two separate excel sheets using Qlickview it automatically creates "$SYN_1" field. The program automatically connects two excel sheets using this field. I want to connect those excel workbooks using its own fields. I want to know how to get rid of this "$SYN_1" fields.

1 Solution

Accepted Solutions
martinpohl
Valued Contributor II

Re: want to remove "$SYN_1" in Qlickview program.

use the qualify statement

for example

qualify *;

This will rename all fields with the tablename as a prefix

Regards

3 Replies
amit_saini
Honored Contributor III

Re: want to remove "$SYN_1" in Qlickview program.

Hi Sagara,

Please follow this:

Synthetic Keys

Thanks,
AS

martinpohl
Valued Contributor II

Re: want to remove "$SYN_1" in Qlickview program.

use the qualify statement

for example

qualify *;

This will rename all fields with the tablename as a prefix

Regards

sagaraperera
New Contributor III

Re: want to remove "$SYN_1" in Qlickview program.

THANKS DEAR

SAGARA

Community Browser