Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagaraperera
Creator
Creator

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
Partner - Master
Partner - Master

use the qualify statement

for example

qualify *;

This will rename all fields with the tablename as a prefix

Regards

View solution in original post

3 Replies
amit_saini
Master III
Master III

Hi Sagara,

Please follow this:

Synthetic Keys

Thanks,
AS

martinpohl
Partner - Master
Partner - Master

use the qualify statement

for example

qualify *;

This will rename all fields with the tablename as a prefix

Regards

sagaraperera
Creator
Creator
Author

THANKS DEAR

SAGARA