Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

change value format for data load

Hello,

let's assume we have two tables and we want to join them via one key field (field1).

But, the value format of the key field in both tables is different:

How can i change the value format of e.g. fieldA (0000000000) of table1

into the value format of field1 (00-000-0000/0) of table2 (master)?

Greets,

G.A.

1 Solution

Accepted Solutions
Highlighted

May be like this:

Left(fieldA, 2) & '-'&Mid(fieldA, 3, 3)& '-' & Mid(fieldA, 6, 4) & '/' & Right(fieldA, 1)

View solution in original post

3 Replies
Highlighted

May be like this:

Left(fieldA, 2) & '-'&Mid(fieldA, 3, 3)& '-' & Mid(fieldA, 6, 4) & '/' & Right(fieldA, 1)

View solution in original post

Highlighted
Specialist
Specialist

Maybe

Autonumber(keepchar(field1,'00' ) ) as FieldA


Autonumber(FieldA) as FieldA

Highlighted
Creator
Creator

As always Sunny, works perfectly fine.

Thanks a lot